Re: Oracle's Equivalent to MS Access Joins
From: Luis Ramirez <lramirez_cl_at_hotmail.com>
Date: Tue, 23 Apr 2002 15:37:07 +0100
Message-ID: <3cc5b792_1_at_nova.entelchile.net>
Date: Tue, 23 Apr 2002 15:37:07 +0100
Message-ID: <3cc5b792_1_at_nova.entelchile.net>
Se utiliza el (+) para los outer joins
where table1.colA(+)=table2.colB ......left where table1.colA=(+)table2.colB ......right
"David O'Sullivan" <o_sullivandavid_at_hotmail.com> escribió en el mensaje
news:3187237f.0204230948.6a23037b_at_posting.google.com...
> Hey All,
>
> I'm manually translating an SQL query from Access to Oracle and I'm
> not sure about the possible Joins. Basically I'm wondering what the
> Oracle equivalent would be of a Left, Right, Left Outer and Right
> Outer joins...
>
> Forgive my ignorance, I just want to be sure.
>
> Thanks in advance!
>
> David
Received on Tue Apr 23 2002 - 16:37:07 CEST