v_proinstore.sql

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

CREATE VIEW dbo.v_proinstore
AS
SELECT p.ProId, SUM(s.ProNum) AS SumNum
FROM dbo.Product p INNER JOIN
      dbo.ProInStore s ON p.ProId = s.ProId
GROUP BY p.ProId