Re: Help Formulating Complex LEFT JOIN Query
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
Subject
Written By
Posted
September 30, 2005 10:46AM
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.