PS/Query
Is it possible to create a PS/Query using the following SQL:
select a.name as EmployeeName, a.supervisor_name as SupervisorName, b.name as NoteAddedBy,
n.HR_NP_CREATE_DTTM as DateCreated, n.HR_NP_NOTE_ID as NoteId,
n.HR_NP_SUBJECT as Subject, n.HR_NP_NOTE_TEXT as Text
from ps_hr_np_note n
, (select * from ps_employees x start with x.SUPERVISOR_ID = '648791' CONNECT BY prior x.EMPLID = x.SUPERVISOR_ID AND x.EMPLID <> X.SUPERVISOR_ID) a,
ps_employees b
where a.emplid = n.hr_np_note_key2
and