title: How to update table A with data from table B?
body: <p>I am trying to update table A with two data values from table B. I thought I could do something like:</p>
  
  <pre><code>UPDATE A
  SET A.DATA1= B.DATA1, A.DATA2= B.DATA2
  FROM TABLE1 A, TABLE2 B
  WHERE A.ID = B.ID;
  </code></pre>
  
  <p>What is the correct syntax?</p>