MySQL Forums
Forum List  »  General

Re: Help Formulating Complex LEFT JOIN Query
Posted by: Roland Bouman
Date: October 01, 2005 05:03PM

select t.*
from trades t
where not exists (
select null
from vendors v
where v.trade = t.trade
and v.company = X
)

wich would be equivalent to:


select t.*
from trades t
left join vendors v
on t.trade = v.trade
and v.company = X
where v.trade is NULL

Options: ReplyQuote


Subject
Written By
Posted
Re: Help Formulating Complex LEFT JOIN Query
October 01, 2005 05:03PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.