Posted by john7 on 03/02/07 18:52

I first posted to MySQL group but decided later that I will get faster
answers from the PHP group as this group is very active.
Thanks for taking time to look into this problem.

John

On Mar 2, 12:48 pm, Rik <luiheidsgoe...@hotmail.com> wrote:
> john7 <johnm...@fastermail.com> wrote:
> > Thanks for your reply, the above statement is returning
>
> > categoryid (count name for products 1) (count name for products 2)
> > 1 2 2
> > 2 1 0
> > 3 2 2
>
> Yup, just discovered that myself. Odd, as the manual states:
> "COUNT() .. Returns a count of the number of non-NULL values in the rows"
>
> And I'd think we'd only have null values with a left join...
> Well, off to comp.databases.mysql it is, I see you multiposted to that
> group already.
> --
> Rik Wasmus

[Back to original message]