Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT COUNT(v.chassis_nr)
- FROM VEHICLE v, VEHICLE_LOAD_DATA vld, VO_VEHICLE_CATEGORY vvc, vehicle_owner vo
- WHERE v.chassis_nr=vld.chassis_nr
- AND v.VO_VEHICLE_CATEGORY_ID=vvc.VO_VEHICLE_CATEGORY_ID
- AND vo.vehicle_owner_id=vvc.vehicle_owner_id
- AND vo.vehicle_owner_id=v.vehicle_owner_id
- AND UPPER(vo.company_name) LIKE UPPER('fabricom')
- AND vvc.VO_VEHICLE_CATEGORY_ID != 102337;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement