Advertisement
DimitarVasilev

Untitled

Jun 14th, 2017
67
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.53 KB | None | 0 0
  1. SELECT oc.name "OC Name", ca.name "CA Name", ca.oc_calendar_id
  2. FROM vehicle_owner vo, oc_calendar ca, operation_center oc, admin_center ac, person p
  3. WHERE ac.admin_center_id=vo.admin_center_id
  4. AND ac.admin_center_id=oc.admin_center_id
  5. AND oc.operation_center_id=ca.operation_center_id
  6. AND vo.oc_calendar_id=ca.oc_calendar_id
  7. AND p.vehicle_owner_id=vo.vehicle_owner_id
  8. AND p.oc_calendar_id=ca.oc_calendar_id
  9. AND p.person_id IN (SELECT person_id FROM gu_person)
  10. AND p.oc_calendar_id IS NULL
  11. AND UPPER(vo.company_name) LIKE 'PUTMAN%';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement