mbsl a écrit:
Essayez :

SELECT DISTINCT Communes.Email AS Email
FROM Communes
WHERE ( Communes.Region IN ('BASSE NORMANDIE', 'HAUTE NORMANDIE', 'ILE DE FRANCE', 'PICARDIE') OR Communes.departem LIKE 'EURE ET LOIR' )
AND Communes.Email <> ''
AND Communes.Email IS NOT NULL