Get clomuns with value 0 on group by sum : I'm using this query to get the sum  of rows  grupued by cmp2 field but I need to get a colum for every cmp2 even if its sum resul is 0, but I can't get it this way

    SELECT CMP2,COALESCE(count(*), 0) as count 
    FROM datos_con851_0,datos_con851_1  
    WHERE datos_con851_0.REGISTRO = datos_con851_1.REGISTRO 
    AND SPEEDER = 1
    GROUP BY CMP2;
