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.