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 -> Re: exists "join"-operation?

Re: exists "join"-operation?

From: Matthias Gresz <GreMa_at_t-online.de>
Date: Thu, 11 Mar 1999 13:57:06 +0100
Message-ID: <36E7BDA2.9C5DD701@t-online.de>

Surfer Netzbetrieb schrieb:
>
> Hello,
>
> does "join"-operator in ORACLE exist? Or are all joins in
> SQL-statements implementated in the where-clause ?
>
> example:
> select .... where table1.tab1_ID = table2.tab2_ID
>
> does something like this exist:
> select .... join table1.tab1_ID on table2.tab2_ID

                NO!

for outer joins use:  

	where  
		table1.tab1_ID = table2.tab2_ID (+)

where table2 is the table that hasn't all ID's from tabel1 in its rows.

HTH
Matthias
--
grema_at_t-online.de

Protect privacy, boycott Intel: http://www.bigbrotherinside.org Received on Thu Mar 11 1999 - 06:57:06 CST

Original text of this message

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