Advertisement
psi_mmobile

Untitled

Jul 31st, 2020
1,983
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 0.27 KB | None | 0 0
  1. SELECT vo.company_name, vopc.name, p.*
  2. FROM person p, vo_person_category vopc, vehicle_owner vo
  3. WHERE p.vo_person_category_id = vopc.vo_person_category_id
  4. AND vopc.vehicle_owner_id = vo.vehicle_owner_id
  5. AND p.cost_per_hour IS NOT NULL
  6. AND p.person_status_id = 0
  7. ORDER BY 1;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement