Combining Results - How To

[jiggyg]

Hello List!

I have a question on how to combine two result sets...

I have two queries that return the same ClientName and the number of each invalid records, and want to combine them into one.

For Example:

SELECT ClientName, count(LocClientID) AS #ofOccurances
FROM [MasterDetails].dbo.getInvalidBmkAssignments(123)
WHERE LocClientID != 105
GROUP BY ClientName

-AND-

SELECT ClientName, count(ClientID) AS #ofOccurances
FROM [MasterDetails].dbo.getUNKNOWNBmkAssignments(123)
WHERE ClientID != 105 
GROUP BY ClientName

Returns me two results:
ONE:
ClientName #ofOccurances
MyClientName 188

TWO:
ClientName #ofOccurances
MyClientName 47


But, what I want is ONE result w/ the #ofOccurances added together:
ClientName #ofOccurances
MyClientName 235


How can I accomplish that?

Thanks in advance for your time and help!
-jiggyg

 

[kaht]

SELECT ClientName, count(LocClientID) AS #ofOccurances
FROM [MasterDetails].dbo.getInvalidBmkAssignments(123)
WHERE LocClientID != 105
GROUP BY ClientName

[!]UNION[/!]

SELECT ClientName, count(ClientID) AS #ofOccurances
FROM [MasterDetails].dbo.getUNKNOWNBmkAssignments(123)
WHERE ClientID != 105
GROUP BY ClientName

-kaht

Lisa, if you don't like your job you don't strike. You just go in every day and do it really half-assed. That's the American way. - Homer Simpson
[small]<P> <B> <P> <B> <P> <B> <P> <B> <P> <B> <P> <B> <P> <B> <P> <B> <P> <B> <P> <B> <P> <B> <P> <B> <P> <B> <P> <.</B> bites again.[/small]

 

[kaht]

Gah, added together, I should have read the whole thread...

select a.ClientName, sum(a.#ofOccurances) from
(
   SELECT ClientName, count(LocClientID) AS #ofOccurances
   FROM [MasterDetails].dbo.getInvalidBmkAssignments(123)
   WHERE LocClientID != 105
   GROUP BY ClientName

   UNION

   SELECT ClientName, count(ClientID) AS #ofOccurances
   FROM [MasterDetails].dbo.getUNKNOWNBmkAssignments(123)
   WHERE ClientID != 105
   GROUP BY ClientName
) a

group by a.ClientName

-kaht

Lisa, if you don't like your job you don't strike. You just go in every day and do it really half-assed. That's the American way. - Homer Simpson
[small]<P> <B> <P> <B> <P> <B> <P> <B> <P> <B> <P> <B> <P> <B> <P> <B> <P> <B> <P> <B> <P> <B> <P> <B> <P> <B> <P> <.</B> bites again.[/small]