Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT v.vehicle_id, MIN(vd.gps_full_date), et.name
- FROM vehicle v, vo_vehicle_category vc, vehicle_owner vo, event_type et, vehicle_data vd
- WHERE v.vo_vehicle_category_id=vc.vo_vehicle_category_id
- AND vc.vehicle_owner_id=vo.vehicle_owner_id
- AND v.vehicle_id=vd.vehicle_id
- AND vd.event_type_id=et.event_type_id
- AND v.fuel_type_id=1
- AND vo.vehicle_owner_id=100573
- AND et.event_type_id=102
- GROUP BY v.vehicle_id, et.name;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement