Archives of the TeradataForum
Message Posted: Wed, 07 May 2003 @ 20:27:30 GMT
| Subj: || || Recursive sql |
| From: || || Michael Embry |
I have an organization chart tree represented in a table with a postion_code and a reports_to_postion_code. I need to follow the tree
with sql to report on everyone who reports to a particular postion.
For example B, C, D report to A and E, F report to D. If I enter the tree at A, I should see that B,C,D,E,F all report to A.
Anyone know how to recursively move through the tree with sql?