SELECT id,
SUM(cnt) AS [Count]
FROM
(
SELECT id_1 AS id,count_1 AS cnt
FROM table1
UNION ALL
SELECT id_2,count_2
FROM table2
)t
GROUP BY id
ORDER BY id
------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
help me Query sum Count 2 table or n table
Posted - 01/10/2013 : 03:21:10
