total_num.sql

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

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