John_Merrick
asked on
3 level Self Join
I want to create a self join that will select classification details to 3 levels. I have tried various syntax but to no avail. Have attached 3 files
.csv is the ouput of code that gets me two levels
.txt is the code for the above
.doc is a screen dump showing a sample of the levels.
I actaullu only need to drill down the tree for subcontractors and suppliers, not interested in the other top levels.
self-join.csv
self-jojn.doc
selj-oin-selct.txt
.csv is the ouput of code that gets me two levels
.txt is the code for the above
.doc is a screen dump showing a sample of the levels.
I actaullu only need to drill down the tree for subcontractors and suppliers, not interested in the other top levels.
self-join.csv
self-jojn.doc
selj-oin-selct.txt
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER