Attaching to a Structure

I have a table of activities:

activity (ID, Name, Element ...)

and a table of structures:

structure (Element, Description, Level, Parent ...)

The Parent points back to another element at a higher level. The tree can be max 10 levels deep for practical purposes.

activity.Element references one structure.Element.

What i need is to produce 1 (one) query to attach activities in their branches to a given level, say 3.

I can't seem to get around with out temporary tables, programming and such.

The implementation is going be both Oracle 7 and 8 and MSSQL, but any hints re welcome.

Thanks

Frans la Cour Received on Tue Feb 01 2000 - 00:00:00 CET