how to do when joints forbidden in hierarchical queries

example of oracle training table

table emp:
empno
ename
job
mgr
hiredate
sal
comm
deptno

table deptno:
deptno
dname
loc

 the following query the hierarchy of employees :

<<select level,ename
from emp
connect by mgr=prior empno
start with mgr is null >>

joints being forbidden in hierarchical queries ,how to add the fields dname and loc in the select clause of the query for obtain a result like select level,ename,dname,loc ... Received on Fri Sep 25 1998 - 13:39:14 CDT