SELECT stf.StaffId, stf.StaffName, stf.Position, stf.ManagerId, mgr.StaffName AS ManagerName, mgr.Position AS ManagerPosition FROM staff AS stf, staff AS mgr where stf.ManagerId=mgr.StaffId