Re: showing also value '0' with aggregate count()

> ERROR:  OUTER JOIN is not yet supported
> (PostgreSQL) 7.0.3
>
> do i need to upgrade or is there a workaround??

Upgrade. :-)

> > There's a great book for SQL called "The Practical SQL Handbook"
> > which covers these types of problems well.  Published by Addison
> > Wesley, written by Bowman, Emerson, and Darnovsky.  Good bedtime
> > reading. :)
>
> can you read my mind?? I am looking for a really good book on SQL. i
> will buy this and we'll see how tired i will be tomorrow..

Bruce's book is a good PostgreSQL book --
http://www.ca.postgresql.org/docs/awbook.html

-Mitch