title: MYSQL how to get single row of policy for each customer by last date
body: <p>i have two table</p>
  
  <p>vehicle_data</p>
  
  <pre><code> id chassis name      number
    1 00001   customer1 123456
    2 00002   customer2 654321
    3 00003   customer3 645421
  </code></pre>
  
  <p>insurance_data</p>
  
  <pre><code> id chassis policy_number expiry_date
    1 00001           11111 22-01-2015
    2 00002           22222 22-01-2015
    3 00003           33333 22-01-2015
    4 00001           44444 22-01-2016
    5 00002           55555 22-01-2017
    6 00001           66666 22-01-2017
  </code></pre>
  
  <p>what i want</p>
  
  <pre><code> chassis name      policy_number expiry_date
     00001 customer1         66666 22-01-2017
     00002 customer2         55555 22-01-2017
     00003 customer3         33333 22-01-2015
  </code></pre>