Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select ccp.*
- from mfc_mobile_worker mfcmw, person p, oc_poi ocp, cal_closing_period ccp, work_code wc, oc_calendar occ, operation_center oc
- where mfcmw.erp_id = p.person_id
- and p.hiring_p_oc_poi_id = ocp.poi_id
- and ocp.oc_calendar_id = ccp.oc_calendar_id
- and ccp.oc_calendar_id = occ.oc_calendar_id
- and occ.operation_center_id = oc.operation_center_id
- and ccp.work_code_id = wc.work_code_id
- and p.person_id = 537437;
Advertisement
Add Comment
Please, Sign In to add comment