union help

[Moxy1]

I have about 3 SQLs that I would like to join together with a Union. The problem that I'm having is with the Group by. Basically what I have is:

select location, '1', count(location)

union

select location, '2', count(location)

union

select location, '3', count(location)


Any ideas?

 

[PHV]

You wanted this ?
select location, '1', count(location) group by location
union
select location, '2', count(location) group by location
union
select location, '3', count(location) group by location

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[PHV]

You wanted this ?
select location, '1', count(location) from ... group by location
union
select location, '2', count(location) from ... group by location
union
select location, '3', count(location) from ... group by location
Or this ?
select location, sum(mycount) total
from (
select location, count(location) mycount from ... group by location
union all select location, count(location) from ... group by location
union all select location, count(location) from ... group by location
) u group by location

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Moxy1]

PH,

I've noticed you around several of the other forums here helping out. Is there anything you don't know?

As always Thank You!!