Re: help with hierarchical selects (SQL)
From: Ian Wilkins <ianw_at_sensible.teleord.co.uk>
Date: 1996/02/22
Message-ID: <4ghm2j$ad6_at_sensible.teleord.co.uk>#1/1
Date: 1996/02/22
Message-ID: <4ghm2j$ad6_at_sensible.teleord.co.uk>#1/1
In article <HARPER.96Feb21124328_at_manitou.utoronto.ca>,
John Harper <harper_at_manitou.astro.utoronto.ca> wrote:
>I'm trying to do a hierarchical selection from some ORACLE DB tables
>using SQL. The manual says do something like:
>
>SELECT EMPNO, LEVEL FROM JOBS START WITH EMPNO < 400
>CONNECT BY PRIOR EMPNO=SUP;
>
Could you not do:
SELECT JOBS.EMPNO, LEVEL FROM JOBS, PERSON
WHERE JOBS.EMPNO = PERSON.EMPNO
START WITH JOBS.EMPNO < 400
CONNECT BY PRIOR JOBS.EMPNO=SUP;
Don't tell me, this is the first thing you tries, and it didn't work?
Oh well, just a suggestion.
Ian. Received on Thu Feb 22 1996 - 00:00:00 CET