v_report2.sql

来自「直接打开」· SQL 代码 · 共 12 行

USE Assets
GO
CREATE VIEW dbo.v_Report2
AS
SELECT dbo.Type.TypeName, 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.Type ON dbo.Assets.TypeId = dbo.Type.TypeId
GROUP BY dbo.Type.TypeName