START WITH and CONNECT BY clause

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 Wed Jun 17 1998 - 00:00:00 CEST