title: SQL getting max date from two tables
body: <p>I have two tables</p>
  
  <pre><code>USER (one row per user)
  
  id,username,firstname,lastname,lastmodified
  1,johns, John,Smith, 2009-03-01
  2,andrews, Andrew,Stiller, 2009-03-03
  
  
  STUDIES (multiple rows per user)
  
  id,username,lastmodified
  1,johns, 2009-01-01
  1,johns, 2009-02-01
  1,johns, 2009-07-01
  2,andrews,2009-05-05
  2,andrews,2009-04-04
  </code></pre>
  
  <p>I want to get users details and the NEWEST date from the two tables:</p>
  
  <pre><code>johns,John,Smith,2009-07-01
  andrews,Andrew,Stiller,2009-05-05
  </code></pre>
  
  <p>Help?</p>