v_takeout.sql

库存管理系统

USE Stock
GO
CREATE VIEW dbo.v_takeout
AS
SELECT p.Pid, SUM(t.Pnum) AS SumNum, SUM(t.Pnum * t.Pprice) 
      AS SumPrice
FROM dbo.Product p INNER JOIN
      dbo.TakeOut t ON p.Pid = t.Pid
GROUP BY p.Pid
GO