Total_Num.sql
资源名称:SQLVC.rar [点击查看]
上传用户:biney012
上传日期:2022-05-09
资源大小:4592k
文件大小:0k
源码类别:
数据库系统
开发平台:
Visual C++
- 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