Re: outer join

From: Witold Iwaniec <wiwaniec_at_novalistech.com>
Date: Tue, 12 Mar 2002 07:03:32 -0800
Message-ID: <F001.004259D3.20020312070332@fatcity.com>

You can have multiple outer joins in the where clause but one table can be outer-joined to one other table only.

For example you can write:

select tb1.col_1
from table1 tb1, table2 tb2, table3 tb3
where tb1.some_col = "some value"
and tb1.col_a(+) = tb2.col_a
and tb2.col_b(+) = tb3.col_b

but you can not write:

select tb1.col_1
from table1 tb1, table2 tb2, table3 tb3
where tb1.some_col = "some value"
and tb2.col_a(+) = tb1.col_a
and tb2.col_b(+) = tb3.col_b

It depends how you need to outer-join the tables But last time I used outer joins it was in I believe Oracle 8.0.5 Maybe something has changed in 8i, or 9i

Witold

On 12 Mar 2002 at 5:23, iashraf_at_csc.com wrote:

>
> Hi,
>
> im trying to create a view comprising of about 10 tables, trying to
> join them together.i need a few outer jojns, but i have been told this
> is not possible, i.e. having numerous outer joins in the where
> clause..
>
> anyone got any info on these rules for outer joins?
>
> cheers
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
> INET: iashraf_at_csc.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message to:
> ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the
> message BODY, include a line containing: UNSUB ORACLE-L (or the name
> of mailing list you want to be removed from). You may also send the
> HELP command for other information (like subscribing).

---

Witold Iwaniec
Sr Software Developer
NovaLIS Technologies
wiwaniec_at_novalistech.com
http://www.novalistech.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Witold Iwaniec
  INET: wiwaniec_at_novalistech.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Tue Mar 12 2002 - 09:03:32 CST