title: MySQL: help needed in query for 4 tables. Looking for id's present in all tables and want to list only the most recent date
body: <p>I have 4 tables with the same column names id and date.  What I am trying to do is get all the id's that appear in all 4 tables and only list the common id by the most recent date.  </p>
  
  <p>For example:</p>
  
  <pre><code>A
  id date
  1  11/30/02
  1  10/01/02
  2  11/15/05
  4  12/01/03
  
  B
  id date
  1 11/30/02
  1 10/01/02
  3 12/1/05
  4 12/01/03
  
  C
  id date
  1  11/30/02
  4  12/01/03
  
  D
  id date
  1  11/30/02
  4  12/01/03
  5  09/01/02
  </code></pre>
  
  <p>Now what I want is to run a query and create another table that will look like this:</p>
  
  <pre><code>E
  id date
  1  11/30/02
  4  12/01/03
  </code></pre>
  
  <p>I have tried many things and have had no luck with any of them.  I would appreciate any help.
  Thank you</p>