I am trying to preform to get an Employee's Boss, Boss's Boss, Boss's Boss's Boss, etc... I am think a self join like below would work.
SELECT Emp, Leader FROM Table AS Table_1JOIN Table as Table_2 ON Table_1.EMP = Table_2.EMP WHERE Table_1.Leader = Table_2.EmpAND Table_1.EMP = 'Employee'
If you where to run this, you only get the person in the And part of the clause and no one else.
Can someone point me into the right direction?
Thank you in advance.
View Complete Post