CREATE VIEW dbo.View_Qyxsl
AS
SELECT TOP 100 PERCENT
FdSsqy,'H' as FdGdd,
(SELECT SUM(FdGmsl) as EwoySl,SUM(FdSsje) as EwoyYs,SUM(FdSsje) AS EwoySs FROM View_Qyxsl1 WHERE View_Qyxsl1.FdSsqy = View_Qy.FdSsqy and View_Qyxsl1.FdMs='EWOY' and View_Qyxsl1.FdGdd='H') FROM View_Qy
order by FdSsqy
不行嗎
AS
SELECT TOP 100 PERCENT
FdSsqy,'H' as FdGdd,
(SELECT SUM(FdGmsl) as EwoySl,SUM(FdSsje) as EwoyYs,SUM(FdSsje) AS EwoySs FROM View_Qyxsl1 WHERE View_Qyxsl1.FdSsqy = View_Qy.FdSsqy and View_Qyxsl1.FdMs='EWOY' and View_Qyxsl1.FdGdd='H') FROM View_Qy
order by FdSsqy
不行嗎
a.FdSsqy,'H' FdGdd,
b.EwoySl,
b.EwoyYs,
b.EwoySs
FROM View_Qy a left join
(SELECT SUM(FdGmsl) EwoySl,SUM(FdYsje) EwoyYs,SUM(FdSsje) EwoySs FROM View_Qyxsl1 WHERE FdMs='EWOY' and FdGdd='H') b
on b.FdSsqy = a.FdSsqy
order by a.FdSsqy
AS
SELECT TOP 100 PERCENT
a.FdSsqy,'H' FdGdd,
b.EwoySl,
b.EwoyYs,
b.EwoySs
FROM View_Qy a left join
(SELECT FdSsqy,SUM(FdGmsl) EwoySl,SUM(FdYsje) EwoyYs,SUM(FdSsje) EwoySs FROM View_Qyxsl1 WHERE FdMs='EWOY' and FdGdd='H' group by FdSsqy) b
on b.FdSsqy = a.FdSsqy
order by a.FdSsqy
AS
SELECT TOP 100 PERCENT
a.FdSsqy,FdGdd='H',b.EwoySl,b.EwoyYs,b.EwoySs
FROM View_Qy a join (
SELECT FdSsqy,EwoySl=SUM(FdGmsl),EwoyYs=SUM(FdYsje),EwoySs=SUM(FdSsje)
FROM View_Qyxsl1 where FdMs='EWOY' and FdGdd='H' group by FdSsqy
) b on a.FdSsqy=b.FdSsqy
order by FdSsqy
AS
SELECT TOP 100 PERCENT
a.FdSsqy,'H' FdGdd,
b.EwoySl,
b.EwoyYs,
b.EwoySs
FROM View_Qy a left join
(SELECT FdSsqy,SUM(FdGmsl) EwoySl,SUM(FdYsje) EwoyYs,SUM(FdSsje) EwoySs FROM View_Qyxsl1 WHERE FdMs='EWOY' and FdGdd='H' group by FdSsqy) b
on b.FdSsqy = a.FdSsqy
order by a.FdSsqy