Re: Left Join, Right Join

From: Sybrand Bakker <postmaster_at_sybrandb.demon.nl>
Date: Thu, 30 Dec 1999 14:59:37 +0100
Message-ID: <946562453.26141.0.pluto.d4ee154e@news.demon.nl>

The latter: Oracle does not use the words left and right join. Just a (+) construct should work.

Hth,

--
Sybrand Bakker, Oracle DBA
Ken Bluttman <kb_at_innmedia.com> wrote in message news:s6mmre705k2127_at_corp.supernews.com...
> I'm converting a Microsoft Access application to Oracle. Some Access
> queries use Left Join or Right Join. What terminolgy is used in Oracle to
> accomplish this. Either I can't find good refererence resources or does
> Oracle not use the words Left or Right for Joins.
>
> I am able to make a plain Outer Join.
>
> Thanks,
>
> Ken
>
>
Received on Thu Dec 30 1999 - 07:59:37 CST