> "Christopher Kings-Lynne" <chriskl@familyhealth.com.au> writes:
> > What's probably happening is that count isn't counting NULLs?
>
> As per spec. If you want to count records independently of whether
> any particular column is NULL or not, use count(*). See the docs,
> notably
> http://www.ca.postgresql.org/users-lounge/docs/7.2/postgres/sql-ex
> pressions.html#SYNTAX-AGGREGATES
OK, Edward - I guess Tom means do this?:
select category.name, count(items.*) 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;
Chris