title: How do I update MySQL column depend on last date
body: <p>Lets say I have two tables</p>
  
  <p>table_1</p>
  
  <pre><code>ID  Name   Status
  1   John   
  2   Peter  
  3   Smith  
  </code></pre>
  
  <p>table_2</p>
  
  <pre><code>ID  UID   Status  UpdateDate
  1   1     B       2010-05-05
  2   1     C       2011-03-02
  3   3     C       2011-03-02
  4   2     A       2011-03-02
  </code></pre>
  
  <p>What is the correct statement to update <code>Status</code> on <code>table_1</code> according to <code>UpdateDate</code> on <code>table_2</code>.</p>
  
  <p>Result should be like this</p>
  
  <p>table_1</p>
  
  <pre><code>ID  Name   Status
  1   John   C
  2   Peter  A
  3   Smith  C
  </code></pre>
  
  <p>Thanks.</p>