1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
| SELECT A.nc, B.loc, C.sie, pays.libelle_pays, communes.libelle
FROM (((communes INNER JOIN pays ON communes.id_pays = pays.id_pays) LEFT JOIN
(SELECT communes.id_commune, Count(employes.status) AS nc
FROM communes, employes
WHERE communes.id_commune=employes.id_commune And employes.status="nc"
GROUP BY communes.id_commune, employes.status
) AS A ON communes.id_commune = A.id_commune) LEFT JOIN
(SELECT communes.id_commune, Count(employes.status) AS loc
FROM communes, employes
WHERE communes.id_commune=employes.id_commune And employes.status="loc"
GROUP BY communes.id_commune, employes.status
) AS B ON communes.id_commune = B.id_commune) LEFT JOIN
(SELECT communes.id_commune, Count(employes.status) AS sie
FROM communes, employes
WHERE communes.id_commune=employes.id_commune And employes.status="sie"
GROUP BY communes.id_commune, employes.status
) AS C ON communes.id_commune = C.id_commune; |
Partager