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

[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..