Re: Left Join, Right Join

Sybrand Bakker (postmaster_at_sybrandb.demon.nl) wrote:
: The latter: Oracle does not use the words left and right join. Just a (+)
: construct should work.

e.g.

Access

        SELECT * FROM TBL1 LEFT JOIN TBL2 WHERE TBL1.KEY=TBL2.KEY2; Oracle

        SELECT * FROM TBL1,TBL2 WHERE TBL1.KEY(+)=TBL2.KEY; (I might have the left/right backwards.)

If you have a multi-column join then the (+) is added to _each_ column in the join.

e.g.

	SELECT * FROM TBL1,TBL2 
	WHERE TBL1.KEY1(+)=TBL2.KEY1
	AND   TBL1.KEY2(+)=TBL2.KEY2 ;

: 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 - 12:24:55 CST