v_takeout.sql

来自「这是一个用visual c＋＋&sql server开发的关于企业库存管理的信息」· 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