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
-- Mark Harrison Pixar Animation Studios
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
