Advertisement
DimitarVasilev

Untitled

Jun 23rd, 2017
68
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.47 KB | None | 0 0
  1. SELECT v.vehicle_id, MIN(vd.gps_full_date), et.name
  2.       FROM vehicle v, vo_vehicle_category vc, vehicle_owner vo, event_type et, vehicle_data vd
  3.       WHERE v.vo_vehicle_category_id=vc.vo_vehicle_category_id
  4.       AND vc.vehicle_owner_id=vo.vehicle_owner_id
  5.       AND v.vehicle_id=vd.vehicle_id
  6.       AND vd.event_type_id=et.event_type_id
  7.       AND v.fuel_type_id=1
  8.       AND vo.vehicle_owner_id=100573
  9.       AND et.event_type_id=102
  10.       GROUP BY v.vehicle_id, et.name;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement