Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Comments
-
Try this SELECT papf.person_number, papf_sup.person_number supervisor_no, ppnf.full_name supervisorname FROM per_all_people_f papf, per_all_assignments_m paam, per_assignment_supervisors_f pasf, per_all_people_f papf_sup, per_person_names_f ppnf WHERE papf.person_id = paam.person_id AND paam.primary_assignment_flag = 'Y'…