Re: exists "join"-operation?

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