Retourner les champs NULL [Résolu]

[okoweb]

Bonjour,

Code :

1
2
3
4
5
6
7
8
9
10
11
12
13
14
 
SELECT m.noms AS noms, s.genre AS sexe, 
CONCAT(COUNT(dl.id_legis), ' - ', GROUP_CONCAT(CAST(dl.id_legis AS CHAR) ORDER BY dl.id_legis SEPARATOR ', ' )) AS liste_legis, 
COUNT(DISTINCT pp.id_parti) AS total_parti, GROUP_CONCAT(DISTINCT pp.sigle ORDER BY pp.id_parti SEPARATOR ", " ) AS liste_parti,
COUNT(DISTINCT dl.id_dpt) AS total_dpt, GROUP_CONCAT(DISTINCT d2.libelledpt ORDER BY d2.libelledpt SEPARATOR ", " ) AS liste_dpt,
r.libelleregion AS region
FROM membres AS m
LEFT JOIN sexe AS s ON m.sexe = s.id_sexe
LEFT JOIN depute_legislatures AS dl ON dl.id_depute = m.id_membre
LEFT JOIN partis_politiques AS pp ON dl.id_parti = pp.id_parti
LEFT JOIN departements AS d2 ON d2.iddpt = dl.id_dpt
LEFT JOIN regions AS r ON r.idregion = d2.idregion
GROUP BY dl.id_depute 
ORDER BY COUNT(dl.id_legis) DESC, m.noms

Cette requête roule bien mais je souhaite retourner uniquement les lignes de résultats dont les champs "r.libelleregion" valent "NULL", une clause WHERE de ce genre

Code :

1
2
3
4
 
...
WHERE r.libelleregion = 'NULL'
...

Mais ca ne marche pas.

Des pistes...

[ced]

Bonjour,

Comme ça :

Code :

1
2
3
...
WHERE r.libelleregion IS NULL
...

ced

[okoweb]

Envoyé par ced

Bonjour,

Comme ça :

Code :

ced

Exactement exact...
Merci