Jointure avec un where intermediaire

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 :)

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"

---