Linking to another table when using CONNECT BY / START WITH...

From: Bert <m_at_ordiplan.com>
Date: 13 Feb 2002 06:42:24 -0800
Message-ID: <1c1fb7d7.0202130642.2caeee73@posting.google.com>

I am using connect by / start with to extract a recurive project table. (projects/sub projects).

Ultimately the last object that is selected from any branch is a document, there is always at least one document at the end.

My list of documents are in another table and the last ID returned in from the project table is a document.

Is there a was I can join the document information to the tree built by the connect by / start with query?

What I would like is:

project 1
sub project 1
document 1
document 2
sub project 2
document 3
document 1
...

Or do I have to build a temporary table to do the join in two steps.

TIA,
Bert Received on Wed Feb 13 2002 - 08:42:24 CST