troubleshooting Question

T-SQL Union

Avatar of TClevel
TClevelFlag for United States of America asked on
Microsoft SQL Server 2008
4 Comments1 Solution353 ViewsLast Modified:
how can I union a statment like this  to get a result like the bottom output

select a, b, c, count(*) As cars from table1
group by a
UNION
select a, b, c, Count(*) AS  houses from table2
group by a

I like the output to look something  like this

a          b            c       Cars    Houses
---       ----          ---     ------   ----------
john    Brown    car     2              2
Kim     Joins      car     3              3
ASKER CERTIFIED SOLUTION
Rajkumar Gs
Software Engineer

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros