Re: connect by clause with join

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 18 Apr 2001 16:43:25 +0200
Message-ID: <5u9rdtovkceujho2r25lqqraddvmvos5pf@4ax.com>

On Wed, 18 Apr 2001 08:16:31 +0100, gg200492 <gg200492_at_ratp.fr> wrote:

>how to do for writing a sql query with "connect by clause and start
>with"
>when we must have a join with another table to show another field?
>
>
>thanks
>
>gil
>

1 use inline views
select *
from
(select statement with connect by)
, other table
where etc

2 Transform the join to a in subquery. Somewhat ugly but will work.

Hth, Received on Wed Apr 18 2001 - 09:43:25 CDT