jobs - How to fetch supervisor id and supervisor name for all employees in ps_job -

i new peoplesoft system, there 1 query retrieve supervisor name , supervisor i'd ps_names table employees of ps_job table. can please tell me how this? , can please tell me result variation using different join condition.

in ps query create query records job , names. ps query suggest join on common emplid fields, since want name of supervisor, refuse suggestion. add join manually adding criterium states supervisor id of job should equal emplid field of names.

you have 2 join options: standard: rows have match returned, job rows empty supervisor id, or rows supervisor id has no corresponding entry in names table excluded left outer join: rows of job shown including no corresponding match in names, selected fields of names table empty.

(making abstraction of effdt)