v_proinstore.sql

用ｖｂ编的一个商品库存管理系统

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