Perfect! Thank you. > -----Original Message----- > From: Harald Fuchs [mailto:[EMAIL PROTECTED] > Subject: Re: Group By Question
> SELECT category_fk, > sum(case status when 1 then 1 else 0 end) AS 'status=1', > sum(case status when 2 then 1 else 0 end) AS 'status=2', > sum(case status when 3 then 1 else 0 end) AS 'status=3' > FROM myTable > GROUP BY category_fk; > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
