[RESOLVED] Need help joining 3 tables

[lpa]

Need help for a very complex MySQL query. Can somebody help? Thanks.

I need to select records from table A which exist in table B, but don't exist in tables C and D. Something like this:

("select tableA.userid, tableB.photo from tableA join tableB on tableA.userid=tableB.id 
#here I need to join table C and table D
where tableA.owner='$myid'");

[laserlight]

A straightforward solution, though not necessarily the most efficient one, would be to use subqueries, e.g.,

SELECT tableA.userid, tableB.photo FROM tableA JOIN tableB ON tableA.userid=tableB.id
    WHERE tableA.owner='$myid' AND tableA.userid NOT IN (SELECT id FROM tableC) AND tableA.userid NOT IN (SELECT id FROM tableD);

[lpa]

Thank you laserlight. It works.