outer joins
I can´t figure out how to create the following SQL
select a.folio, a.tipo, a.date
from solic a, order b
where a.id = b.id_sdc and b.tipo!=399 and b.tipo!=398
so far so good
besides, I want the rows from table a with no match in table b
select a.folio, a.tipo, a.date
from solic a, order b
where (a.id = b.id_sdc and b.tipo!=399 and b.tipo!=398)
or a.id not in (select id_sdc from b)
this select does not work with the version I have. I tried using the left join but couldn´t get the right rows...
Thanks for the help
Subject
Written By
Posted
outer joins
August 23, 2005 10:28AM
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.