|Subject:||Recursive results of a n-level hierarchy|
|Posted by:||bikeratbrown (bikeratbro…@yahoo.com)|
|Date:||4 Jan 2005|
I need to send a flat representation of our Acct Rep Team and
Management groups to an external app. This data should be structed in
a way that would allow access to the owned accts in a reporting
environment to all Reps and their Managers. In other words I need any
level of manager to have rights to all accounts they own and to
accounts where a Rep anywhere below them is that account's Rep.
For example from these two given tables:
How would I get this result:
I thought connect by/start with was my solution but don't see how I can
get the recursive results set desired. Any help is appreciated!