SQL заявка с coalesce

loggers

Registered
Код:
SELECT TOP 1000 CharacterName,  Point 

		+ coalesce
		((SELECT sum(Point) 
		FROM EVENT_INFO2008 
		WHERE EVENT_INFO2008.CharacterName=EVENT_INFO.CharacterName),0)

		+coalesce
		((SELECT sum(Point) 
		FROM EVENT_INFO2009 
		WHERE EVENT_INFO2009.CharacterName=EVENT_INFO.CharacterName),0) 

		AS sumPoints 
		FROM EVENT_INFO WHERE CharacterName='Fine'
		ORDER BY sumPoints DESC

Ако това изкара 4 резултата на героя Fine как тяхните Point да се сумират и да изкара само 1 резултат с общия брой на 4-те резултата?
 

Back
Горе