Advertisement
DimitarVasilev

Untitled

Jun 13th, 2017
73
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.38 KB | None | 0 0
  1. SELECT COUNT(v.chassis_nr)
  2. FROM VEHICLE v, VEHICLE_LOAD_DATA vld, VO_VEHICLE_CATEGORY vvc, vehicle_owner vo
  3. WHERE v.chassis_nr=vld.chassis_nr
  4. AND v.VO_VEHICLE_CATEGORY_ID=vvc.VO_VEHICLE_CATEGORY_ID
  5. AND vo.vehicle_owner_id=vvc.vehicle_owner_id
  6. AND vo.vehicle_owner_id=v.vehicle_owner_id
  7. AND UPPER(vo.company_name) LIKE UPPER('fabricom')
  8. AND vvc.VO_VEHICLE_CATEGORY_ID != 102337;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement