ERP-EIP-OA-Portal

Development Platform:

Visual C++

Total_Num.sql：Code Content

							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

						