Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT oc.name "OC Name", ca.name "CA Name", ca.oc_calendar_id
- FROM vehicle_owner vo, oc_calendar ca, operation_center oc, admin_center ac, person p
- WHERE ac.admin_center_id=vo.admin_center_id
- AND ac.admin_center_id=oc.admin_center_id
- AND oc.operation_center_id=ca.operation_center_id
- AND vo.oc_calendar_id=ca.oc_calendar_id
- AND p.vehicle_owner_id=vo.vehicle_owner_id
- AND p.oc_calendar_id=ca.oc_calendar_id
- AND p.person_id IN (SELECT person_id FROM gu_person)
- AND p.oc_calendar_id IS NULL
- AND UPPER(vo.company_name) LIKE 'PUTMAN%';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement