Re: can I use two join in a single query ?

[Peter Brawley]

Return all rows in a which match rows in b which match or don't match rows in c:

select a.*
from a
join b on a.akey=b.bkey
left join c on b.bkey=c.ckey;

Return all rows in a which match or don't match rows in b which match rows in c:

select a.*
from a
left join b on a.akey=b.bkey
join c on b.bkey=c.ckey;