v_proinstore.sql

库存管理系统

USE Stock
GO
CREATE VIEW dbo.v_ProInStore
AS
SELECT p.Pid, SUM(s.Pnum) AS SumNum
FROM dbo.Product p INNER JOIN
      dbo.ProInStore s ON p.Pid = s.Pid
GROUP BY p.Pid
GO