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

Home -> Community -> Usenet -> c.d.o.server -> FULL JOIN syntax vs (+)

FULL JOIN syntax vs (+)

From: Domenic G. <domenicg_at_hotmail.com>
Date: 12 Nov 2003 12:42:44 -0800
Message-ID: <c7e08a19.0311121242.46df9b3d@posting.google.com>


Is there a way to simulate a two-way outer join using (+) ...

ie.

select a.*, b.* from a full join b on a.whatever = b.whatever;

Can I do this without the "FULL JOIN" syntax in 9i using just (+)??

Dom. Received on Wed Nov 12 2003 - 14:42:44 CST

Original text of this message

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