Re: Recursive Queries

As far as I can remember, hierarchical retrieval is only possible with a single table.
You would have to combine your two tables into a single table and add an extra
column to indicate filetype - e.g. directory, executable, config file.

Phillip Whettlock, CYRANO (UK) Ltd.

Gerard M. Averill wrote in message <7g5e4q$10fc$1_at_news.doit.wisc.edu>...
>In article <37261D84.19D7AF13_at_geopak.com>, Paul Schrum <Paul_at_geopak.com>
wrote:
>
><snipped details of problem>
>
>Paul, first read up on Oracle's extended SELECT syntax to facilitate just
>these types of hierarchical queries. See the section "Hierarchical
Queries"
>under the SELECT command documentation in "Oracle7 Server SQL Reference
>Manual".
>
>The concepts are quite straight-forward and you'll have no problem doing
what
>you outlined in your post. Hope this helps.
>
>Gerard
>
>----
>Gerard M. Averill, Researcher
>CHSRA, University of Wisconsin - Madison
>GAverill<at>chsra<dot>wisc<dot>edu
Received on Wed Apr 28 1999 - 02:43:16 CDT