参考以下SQL：
SELECT AaaUser.FIRST_NAME "FullName",AaaLogin.NAME "LoginName", reportingTo.FIRST_NAME "Reporting To", al.name"Reporting To Login Name",CASE WHEN um.managerrole =1 THEN 'Show all their department requests' WHEN um.managerrole =2 THEN 'Show all their Site requests' WHEN um.managerrole =4 THEN 'Show All Request' ELSE 'Show only their request' END "Requester allowed to view" FROM AaaUser
INNER JOIN SDUser ON AaaUser.USER_ID=SDUser.USERID
LEFT JOIN AaaLogin ON AaaUser.USER_ID=AaaLogin.USER_ID
LEFT JOIN AaaUser reportingTo ON SDUser.REPORTINGTO=reportingTo.USER_ID
LEFT JOIN AaaLogin al On al.user_id=reportingto.user_id
LEFT JOIN UserManager um on um.userid=aaauser.user_id