Re: how to do when joints forbidden in hierarchical queries

Christopher Beck wrote in message
<360c01ee.24633501_at_dcsun4.us.oracle.com>...

>select a.l, a.ename, d.dname, d.loc
> from dept d,
> ( select level l, ename, deptno
> from emp
> connect by mgr=prior empno
> start with mgr is null ) a
> where a.deptno = d.deptno
>/

But this SELECT doesn't return rows in "hierachical" order. IMHO you must use PL/SQL. Received on Mon Sep 28 1998 - 08:30:14 CDT