Filtrar consulta por region

[gnzsoloyo]

Código MySQL:

SELECT   rpe, COUNT (a.rpe) Total
    FROM catusuario c LEFT JOIN agenda a ON c.rpe = a.rpe
   WHERE     TRUE
         AND c.regio = XXX
      OR c.rpe IS NULL
GROUP BY rpe
ORDER BY total ASC;
 

La otra es más simple así:

Código MySQL:

SELECT  a.rpe, COUNT (*) TOTAL
    FROM  agenda a LEFT JOIN catusuario c ON a.rpe = c.rpe
   WHERE TRUE OR c.rpe IS NULL
GROUP BY a.rpe
ORDER BY total ASC