v_takeout.sql

来自「这是一个库存管理系统」· SQL 代码 · 共 10 行

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