v_takeout.sql

来自「企业库存管理系统」· SQL 代码 · 共 9 行

CREATE VIEW dbo.v_takeout
AS
SELECT p.ProId, SUM(t.ProNum) AS SumNum, SUM(t.ProNum * t.ProPrice) 
      AS SumPrice
FROM dbo.Product p INNER JOIN
      dbo.TakeOut t ON p.ProId = t.ProId
GROUP BY p.ProId