Събиране с заявка от много таблици

[XTYLING]

SELECT TOP 100 CharacterName, Class, Point+coalesce((SELECT sum(Point) FROM EVENT_INFO2008 WHERE EVENT_INFO2008.CharacterName=EVENT_INFO.CharacterName),0) AS sumPoints FROM EVENT_INFO ORDER BY sumPoints DESC

искам да добавя още една таблица същата с същите полета но да е EVENT_INFO2009 и да събира от всички таблици
как ще стане това

 

[raiden]

SELECT TOP 100 CharacterName, Class, 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 ORDER BY sumPoints DESC