求助：关于一个视图的问题？

[gesnpt]

CREATE VIEW dbo.View_Qyxsl
AS
SELECT TOP 100 PERCENT
FdSsqy,'H' as FdGdd,
(SELECT SUM(FdGmsl) FROM View_Qyxsl1 WHERE View_Qyxsl1.FdSsqy = View_Qy.FdSsqy and View_Qyxsl1.FdMs='EWOY' and View_Qyxsl1.FdGdd='H') AS EwoySl,
(SELECT SUM(FdYsje) FROM View_Qyxsl1 WHERE View_Qyxsl1.FdSsqy = View_Qy.FdSsqy and View_Qyxsl1.FdMs='EWOY' and View_Qyxsl1.FdGdd='H')
AS EwoyYs,
(SELECT SUM(FdSsje) FROM View_Qyxsl1 WHERE View_Qyxsl1.FdSsqy = View_Qy.FdSsqy and View_Qyxsl1.FdMs='EWOY' and View_Qyxsl1.FdGdd='H')
AS EwoySs,
FROM View_Qy
order by FdSsqy
上面的三个子句的where条件是一样的，请问用什么方法可以把上面的三个子句写成一个子句呢？？？

[sunsunup]

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
不行嗎

[pengdali]

SELECT TOP 100 PERCENT
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

[pengdali]

CREATE VIEW dbo.View_Qyxsl
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

[zjcxc]

CREATE VIEW dbo.View_Qyxsl
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

[tangxc2003]

CREATE VIEW dbo.View_Qyxsl
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

[gesnpt]

象你们这样写的话，和我那样写产生的临时表哪一个更多呢？？？？