Re: START WITH and CONNECT BY clause

START WITH and CONNECT BY clause wont work with Join so you can not have a join in the same query. Even you can not have a view in this statement , which is using join.
Although you can join the result of START WITH and CONNECT BY query to other query.

David Sisk wrote in message ...
>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 Sun Jun 21 1998 - 00:00:00 CDT