v_report1.sql

来自「用visual c＋＋＆sql开发的企业固定资产管理系统。」· SQL 代码 · 共 12 行

USE Assets
GO
CREATE VIEW dbo.v_Report1
AS
SELECT dbo.Departments.DeptName, COUNT(dbo.v_DisCount.AId) AS CountAid, 
      SUM(dbo.v_DisCount.OrgPrice) AS SumOrgPrice, SUM(dbo.v_DisCount.LastPrice) 
      AS SumLastPrice, SUM(dbo.v_DisCount.DisPrice) AS SumDisPrice
FROM dbo.v_DisCount INNER JOIN
      dbo.Assets ON dbo.v_DisCount.Id = dbo.Assets.Id INNER JOIN
      dbo.Departments ON dbo.Assets.DeptId = dbo.Departments.DeptId
GROUP BY dbo.Departments.DeptName