title: mysql update column with value from another table
body: <p>I have two tables, both looking like</p>
  
  <pre><code>id  name  value
  ===================
  1   Joe     22
  2   Derk    30
  </code></pre>
  
  <p>I need to copy the value of <code>value</code> from <code>tableA</code> to <code>tableB</code> based on check name in each table.</p>
  
  <p>Any tips for this <code>UPDATE</code> statement?</p>