title: Update with two tables?
body: <p>I am trying to update table A with data from table B. I thought I could do
   something like:</p>
  
  <pre><code> UPDATE A
   SET A.name = B.name
   WHERE A.id = B.id
  </code></pre>
  
  <p>but alas, this does not work.</p>
  
  <p>Anyone have an idea of how I can do this?</p>