Re: Left Outer Join Question

Chris,
This has not fixed it.
Thanks for your post.
Regards
Ed Murray

>> 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
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org