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 |
I think you are correct in not using OIDs, as, firstly, as you point out
they are optional, also that they are not neccessarily unique.
The use of sequences is an idea, however, why the complication? Why not
simply use a sequence called "mytable_sequence", or "mytable_id" where
"mytable" is the n
Hi
I have just released SHSQL under the GPL, it is a method how SQL can be
easily integrated into shell scripts.
The web site is at http://www.edlsystems.com/shsql and can be downloaded
from ftp://ftp.edlsystems.com/shsql
(Needless to say a PostgreSQL version is included)
Enjoy
Eddy
--
Edward
