[在线等]请教一个多表查询语句 关键字：INNER JOIN, SUM, GROUP BY

[iheshi]

请问能把以下的语句合并为一个SQL语句么？SQL学得不太好。
CREATE VIEW A
AS
SELECT EventID, SUM(Hours) AS TotalHours FROM dbo.UserInfo_EventInfo_Link GROUP BY EventID
GO
CREATE VIEW B
AS
SELECT DISTINCT dbo.EventInfo.EventID, dbo.EventInfo.EventType, dbo.EventInfo.EventName,
dbo.EventInfo.EstimatedCost, dbo.EventInfo.StartDate
FROM dbo.EventInfo INNER JOIN
dbo.UserInfo_EventInfo_Link ON
dbo.EventInfo.EventID = dbo.UserInfo_EventInfo_Link.EventID
GO
SELECT B.*, A.* FROM A, B WHERE A.EventID = B.EventID
DROP VIEW A
DROP VIEW B

[xyxfly]

try:
SELECT B.*, A.* from
(SELECT EventID, SUM(Hours) AS TotalHours FROM dbo.UserInfo_EventInfo_Link GROUP BY EventID)A,(
SELECT DISTINCT dbo.EventInfo.EventID, dbo.EventInfo.EventType, dbo.EventInfo.EventName,
dbo.EventInfo.EstimatedCost, dbo.EventInfo.StartDate
FROM dbo.EventInfo INNER JOIN
dbo.UserInfo_EventInfo_Link ON
dbo.EventInfo.EventID = dbo.UserInfo_EventInfo_Link.EventID) B WHERE A.EventID = B.EventID

[iheshi]

研究研究。。。
学习学习。。。
马上放分。。。
^_^

[xeqtrl982]

我接分！

[iheshi]

。。。。。。。。。
唉，头脑短路了。分要白送了。。。^_^

[jaway]

搂主送分，接分

[xyxfly]

^_^

[iheshi]

给分，收工！^_^