Re: Tree Walking/Connect By

From: Tom Baker <cooljazz_at_halcyon.com>
Date: 1995/04/16
Message-ID: <cooljazz.5.0017A109_at_halcyon.com>#1/1


In article <D5G4yH.MH4_at_westminster.ac.uk> scoec_at_westminster.ac.uk (Michael J Dorey) writes:
>From: scoec_at_westminster.ac.uk (Michael J Dorey)
>Subject: Tree Walking/Connect By
>Date: Tue, 14 Mar 1995 20:01:29 GMT
 

>I am using CONNECT BY to produce an organisational chart based on an employee
>details table. However, I also want to include some department info (from
>another table). I know that you cannot have a join *and* a connect by in
>the same select statement, but is there any way round this, so that data
>from another table can be incorporated??? I have tried creating a view
>which has the employee-department join in it, and then using CONNECT BY
>on the view, but I am *still* getting an error 'ORA-01437: cannot have join
>with CONNECT BY'. I always assumed that a view would always behave as
>a base table for further operations regardless of it's underlying logic,
>but obviously that is not the case. Does anyone else have any experience
>of using CONNECT BY on anything other than a single base table??
>Many thanks,
 

> Michael
 

> m.j.dorey_at_westminster.ac.uk
Received on Sun Apr 16 1995 - 00:00:00 CEST

Original text of this message