Re: combining two queries?

select b.name as viewer, count(*)
from viewer_movies a, xenons b
where b.id = a.viewerid
group by b.name


On Sat, 2004-10-23 at 00:55, Mark Harrison wrote:
> How can I combine these two queries?
>
> # select viewerid,count(*) from viewer_movies group by viewerid order by viewerid;
>   viewerid  | count
> ----------+--------
>   22964835 |   3055
>   22964836 |   1291
>   22964837 |   3105
>   22964838 |    199
>
>
> planb=# select name from xenons where id = 23500637;
>    name
> ---------
>   x.moray
>
> I would like to end up with a query result like this:
>
>   viewer   | count
> ----------+--------
>   x.surf   |   3055
>   x.dream  |   1291
>   x.moray  |   3105
>   x.sleepy |    199
>
> Many TIA!
> Mark
--
Edward A. Macnaghten
http://www.edlsystems.com