Re: LEFT JOIN WHERE GROUP BY

[irek kordirko]

Hello Daniel,

try this query:

SELECT ifnull( cnt, 0 ) count, name
FROM (
    SELECT statusinternal_id, count(*) as cnt
    FROM support 
    WHERE ( create_date >= '2011-02-01 00:00:00' 
    AND create_date <= '2011-02-31 23:59:59' )
    GROUP BY statusinternal_id 
) as x
RIGHT JOIN support_internalstatus s
ON x.statusinternal_id = s.id
;

+-------+----------------------+
| count | name                 |
+-------+----------------------+
|     2 | Wrong item delivered |
|     3 | Exchanged            |
|     2 | Warranty expired     |
|     0 | Warranty             |
+-------+----------------------+
4 rows in set (0.00 sec)