v_storein.sql

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

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