[mysql] Prendere valore non uguale a, su left join

[Al_katraz984]

Salve raga,


ho questa query:

$query = "SELECT * FROM artisti AS a LEFT JOIN 
                file AS f ON a.aid = f.aid LEFT JOIN 
                avatar AS av ON a.aid = av.aid LEFT JOIN 
                ruoli_utenti AS ru ON a.aid = ru.aid AND ru.rid != 3
                WHERE  a.aid = '%d'"; 

La query funzia ma non mi scarta i valori di "ruoli_utente != 3" come posso ottimizzare???

Thanks

[PNK89]

Prova così:

$query = "SELECT * FROM artisti AS a LEFT JOIN
                file AS f ON a.aid = f.aid LEFT JOIN
                avatar AS av ON a.aid = av.aid LEFT JOIN
                ruoli_utenti AS ru ON a.aid = ru.aid AND NOT ru.rid = 3
                WHERE  a.aid = '%d'"; 

[Al_katraz984]

Niente non lo prende..


ho provato anche:

$query = "SELECT * FROM artisti AS a LEFT JOIN
                file AS f ON a.aid = f.aid LEFT JOIN
                avatar AS av ON a.aid = av.aid LEFT JOIN
                ruoli_utenti AS ru ON a.aid = ru.aid 
                WHERE  a.aid = '%d' AND NOT ru.rid = 3";

$query = "SELECT * FROM artisti AS a LEFT JOIN
                file AS f ON a.aid = f.aid LEFT JOIN
                avatar AS av ON a.aid = av.aid LEFT JOIN
                ruoli_utenti AS ru ON a.aid = ru.aid AND ru.rid <> 3 
                WHERE  a.aid = '%d'"; 

ma niente..

[Al_katraz984]

Scusate ho risolto.. guardavo la query sbagliata.. li mortaccci