From: Sybrand Bakker Newsgroups: comp.databases.oracle.misc Subject: Re: connect by clause with join Date: Wed, 18 Apr 2001 16:43:25 +0200 Message-ID: <5u9rdtovkceujho2r25lqqraddvmvos5pf@4ax.com> Reply-To: postbus@sybrandb.demon-verwijderdit.nl Expires: 4 References: <3ADD3F4F.2CE30720@ratp.fr> X-Newsreader: Forte Agent 1.8/32.548 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Complaints-To: abuse@nl.demon.net NNTP-Posting-Host: sybrandb.demon.nl X-NNTP-Posting-Host: sybrandb.demon.nl:212.238.21.78 X-Trace: beta-news.demon.nl 987604877 beta-news:34732 NO-IDENT sybrandb.demon.nl:212.238.21.78 Lines: 22 On Wed, 18 Apr 2001 08:16:31 +0100, gg200492 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,