Re: START WITH and CONNECT BY clause

START WITH and CONNECT BY will only work with a heirarchy that is established within a single table. You, can however, join other tables to this result set.

Hope this helps,
Dave

Elton Chan <97980015r_at_polyu.edu.hk> wrote in message <6m83d0$1ut2_at_hkpa05.polyu.edu.hk>...
>Hi all,
>
> Anybody can tell if the "start with" and "connect by" clause to select
>rows in a hierarchical order is valid for single table or multiple table?
>
> Hence, if I have multiple tables and have some hierarchical relations
>among each tables, and I would like to navigate within the tables to find
>the child and parent, can I use the start with and connect by? Or all the
>hierarchical information must be placed in the same table??
>
>Please help.
>
>Elton
>
>
Received on Thu Jun 18 1998 - 00:00:00 CEST