Hi, All, I am trying to figure out the syntax for doing joins between subsets of the same table.
I have:
Employee ( EmpId PK , EmpFirst, EmpLast, EmpMid, DateHired, SSN, DateBirth, Gender, PhoneNum, ReportsTo)
And I want to find , for each employee, the person they report to.
So I am...