title: MYSQL - Join most recent matching record from one table to another
body: <p>I have two tables that look like this:</p>
  
  <p>Table: cases</p>
  
  <p>id<br>
  name<br>
  status<br>
  case_no  </p>
  
  <p>Table: notes</p>
  
  <p>id<br>
  case_id<br>
  note_date<br>
  notes  </p>
  
  <p>I'd like to be able to create a query that grabs the data from the cases table and only the most recent entry from the notes table for each row in the cases table. So far I'm having no luck at all. </p>
  
  <p>Any pointers would be greatly appreciated</p>