Re: LEFT JOIN WHERE GROUP BY

[Daniel Flöijer]

Thanks, but it still doesn't work when I add the WHERE statement. Ie like this:

SELECT sum( case when s.statusinternal_id is null then 0 else 1 end ) count, name
FROM support s
RIGHT JOIN support_internalstatus si
ON si.id = s.statusinternal_id
WHERE create_date >= '2011-02-21 00:00:00'
AND create_date <= '2011-02-31 23:59:59'
GROUP BY si.id

I then get this:

+-------+----------------------+
| count | name |
+-------+----------------------+
| 2 | Warranty |
| 4 | Wrong item delivered |
| 4 | Exchanged |
+-------+----------------------+

Instead of this:

+-------+----------------------+
| count | name |
+-------+----------------------+
| 2 | Warranty |
| 4 | Wrong item delivered |
| 4 | Exchanged |
| 0 | Warranty expired |
+-------+----------------------+