Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> outer join with critetia on outer table

outer join with critetia on outer table

From: gil guerillot <gil.guerillot_at_ratp.fr>
Date: Wed, 28 Nov 2001 16:42:28 +0100
Message-ID: <9u30j5$a68$1@gotix.reseau.ratp>


i want to select in 2 tables with outer join one criteria of the where clause is on the outer table(FK) and i want also the records (PK) when no row coresponding .

how to do it ? Received on Wed Nov 28 2001 - 09:42:28 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US