1 2 3 4 5
| SELECT T_Adherents.numero, T_Adherents.civilite, T_Adherents.nom_adhe, T_Adherents.prenom, T_Adherents.coadherent AS Coadherent, T_Adherents.adresse, T_Adherents.adresse2, T_Adherents.code_postal, T_Adherents.lieu AS Ville, Count(nz(T_Circuits.code,0)) AS NbrPR
FROM T_Adherents LEFT JOIN T_Circuits ON T_Adherents.numero = T_Circuits.numero_adhe
GROUP BY T_Adherents.numero, T_Adherents.civilite, T_Adherents.nom_adhe, T_Adherents.prenom, T_Adherents.coadherent, T_Adherents.adresse, T_Adherents.adresse2, T_Adherents.code_postal, T_Adherents.lieu
HAVING (((Count(Nz(T_Circuits.code,0)))<2))
ORDER BY T_Adherents.numero; |
Partager