Re: Left Outer Join Question - Mailing list pgsql-sql

> select category.name, count(items.recordnum) from category left outer join
> items on (category.recordnum = items.catnum) where category.recordnum =
> section_subcats.catnum and section_subcats.sectionnum = 1 and
> items.clientnum = 333 group by category.name;

Try using:

count(coalesce(items.recordnum, 0))

instead of:

count(items.recordnum)

I can't guarantee that it will work - I haven't tried it myself.  What's
probably happening is that count isn't counting NULLs?

Chris