Jointure avec un where intermediaire [Résolu]

[AyManoVic]

salut
pour cette requête

Code :

1
2
3
4
$sql=$db->query("SELECT c.id AS id, c.maker AS maker,c.fid AS fid,u.name AS name,f.subject AS subject,c.date AS date,c.numero AS numero
			FROM ".prefix."candidature AS c  
			LEFT JOIN ".prefix."user as u ON (c.maker=u.id) AND (c.id=u.id) 
			LEFT JOIN ".prefix."forum as f ON (c.fid=f.id)",__file__,__line__);

je voulais faire une selection pour un champs status non null
comment je devrais faire ?
un essai :

Code :

1
2
3
4
$sql=$db->query("SELECT c.status,  c.id AS id, c.maker AS maker,c.fid AS fid,u.name AS name,f.subject AS subject,c.date AS date,c.numero AS numero
			FROM ".prefix."candidature AS c  
			LEFT JOIN ".prefix."user as u ON (c.maker=u.id) AND (c.id=u.id) AND(IS NOT NULL(c.status)
			LEFT JOIN ".prefix."forum as f ON (c.fid=f.id)",__file__,__line__);

ça marche pas mais je pense que ça ressemble à ça

[m4riachi]

Est-ce que t'a aissayé avec

Code :

1
2
3
4
5
 
"SELECT c.id AS id, c.maker AS maker,c.fid AS fid,u.name AS name,f.subject AS subject,c.date AS date,c.numero AS numero
			FROM ".prefix."candidature AS c  
			LEFT JOIN ".prefix."user as u ON (c.maker=u.id) AND (c.id=u.id) 
			LEFT JOIN ".prefix."forum as f ON (c.fid=f.id) where c.status not null"