combining results of two select statements
Posted
by ErnieStings
on Stack Overflow
See other posts from Stack Overflow
or by ErnieStings
Published on 2010-05-13T12:16:06Z
Indexed on
2010/05/13
12:34 UTC
Read the original article
Hit count: 165
I'm using T-SQL with ASP.NET, and c# and i'm pretty new to SQL.
I was wondering how i could combine the results of two queries
Query1:
SELECT tableA.Id, tableA.Name, [tableB].Username AS Owner, [tableB].ImageUrl, [tableB].CompanyImageUrl, COUNT(tableD.UserId) AS NumberOfUsers
FROM tableD RIGHT OUTER JOIN
[tableB] INNER JOIN
tableA ON [tableB].Id = tableA.Owner ON tableD.tableAId = tableA.Id
GROUP BY tableA.Name, [tableB].Username, [tableB].ImageUrl, [tableB].CompanyImageUrl
Query2:
SELECT tableA.Id, tableA.Name, COUNT([tableC].Id) AS NumberOfPlans
FROM [tableC] RIGHT OUTER JOIN
tableA ON [tableC].tableAId = tableA.Id
GROUP BY tableA.Id, tableA.Name
Any help would be much appreciated. Thanks in advance
© Stack Overflow or respective owner