Sql query is not workinkg
Content
Hi,
trying to excute the following sql via BI publisher per support document: Doc ID 2187087.1
Select * from per_assignment_supervisors_f sup,
per_all_people_f pers,
per_all_assignments_m assign1
where manager_assignment_id in (select distinct assign.assignment_id from per_all_assignments_m assign where PERIOD_OF_SERVICE_ID = '100000000307865')
and assign1.assignment_id = sup.assignment_id
and pers.person_id = sup.person_id;
getting error ! see screenshot
glad if someone can assist!
thank you!!
Version
18BCode Snippet
Select * from per_assignment_supervisors_f sup, per_all_people_f pers, per_all_assignments_m assign1 where manager_assignment_id in (select distinct assign.assignment_id from per_all_assignments_m assign where PERIOD_OF_SERVICE_ID = '100000000307865') and assign1.assignment_id = sup.assignment_id and pers.person_id = sup.person_id;