Re: joins on results of joins

From: Marc Billiet <first.last_at_com.hydro.switch.this>
Date: Mon, 16 Jul 2001 09:58:46 GMT
Message-ID: <20010716.9584617@y1032960.hae.hydro.com>

With an inline view, you can solve many problems:

select *
from tablename1, (
  select tablename3.column1
  from tablename2, tablename3
  where tablename2.column1(+) = tablename3.column1) iv where tablename1.column1(+) = iv.column1

Marc

>>>>>>>>>>>>>>>>>> Oorspronkelijk bericht <<<<<<<<<<<<<<<<<<

Op 2001-07-14, 23:06:53, schreef "james A" <james.akerman_at_btinternet.com
>

over het thema joins on results of joins:

> could someone please tell me how you can join a table with the result
of
> another join. With normal, left and right outer joins.

> for example:

> tablename1 -- with a left outer join on

> tablename2(+) = tablename3

> any help is most welcome.
Received on Mon Jul 16 2001 - 04:58:46 CDT