"How do I fetch the an employee with his name/emplid and oprid along with his supervisor ID/name and oprid in PS QUERY? Below is the query for reference. I tried adding all the required fields in the O/P but not able to fetch supervisor name along with the others. SELECT A.EMPLID, I.ROLEUSER, B.NAME, A.SUPERVISOR_ID, I.ROLEUSER_SUPR FROM PS_C1_JOB_DTL_VW3 A, PS_PERSONAL_DATA B, PS_ROLEXLATOPR I WHERE B.EMPLID = A.EMPLID AND B.ALTER_EMPLID NOT LIKE 'ING%' AND EXISTS (SELECT 'x' FROM PS_PERSONAL_DATA C, PS_ROLEXLATOPR D, PSOPRDEFN E WHERE C.EMPLID = D.EMPLID AND C.EMPLID = E.EMPLID AND C.EMPLID = A.SUPERVISOR_ID AND C.ALTER_EMPLID LIKE 'ING%' AND ( D.ROLEUSER_ALT = ' ' OR ( D.EFFDT_FROM >= SYSDATE AND D.EFFDT_TO <= SYSDATE)) AND NOT EXISTS (SELECT 'x' FROM PSROLEUSER F WHERE F.ROLEUSER = E.OPRID AND F.ROLENAME IN ('C1_EX_User','C1_PO_Epro','C1_PV_PunchOutSpro','C1_AP_INV_USER'))) AND EXISTS (SELECT 'x' FROM PSOPRDEFN G WHERE G.EMPLID = A.EMPLID AND EXISTS (SELECT 'x' FROM PSROLEUSER H WHERE H.ROLEUSER = G.OPRID AND H.ROLENAME IN ('C1_EX_User','C1_PO_Epro','C1_PV_PunchOutSpro','C1_AP_INV_USER'))) AND B.EMPLID = I.EMPLID"