Posted by Rik on 03/02/07 18:48

john7 <johnmark@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]