Help for this page

Select Code to Download

Select or download this

SELECT s1.StaffId, s1.StaffName, s1.Position, s1.ManagerId, s2.StaffNa
+me AS ManagerName, s2.Position AS ManagerPosition
FROM staff AS s1 INNER JOIN staff AS s2 ON(s1.ManagerId=s2.StaffId)