asked
Summing Counts from Multiple Tables
--Supplier Count SELECT id, COUNT (*) AS cnt FROM atable WHERE id IN ('1','2',3') GROUP BY id ORDER BY id --id Count SELECT id, COUNT (*) AS cnt FROM btable WHERE id IN ('1','2',3') GROUP BY id ORDER BY id How do I add the Count of id's1,2,3 from atable and btable in one piece of code without having to process atable and btable separately then adding the Counts for each supplier in Excel?
The [UNION][1] operator will allow you to return these counts as one set. If your data values may overlap (and you want to then group these and return the sum) as your question implies, then I suggest using UNION ALL in a CTE and then selecting from that the ID and the SUM of the counts. [1]:
http://msdn.microsoft.com/en-gb/library/ms180026.aspx
15 People are following this question.
