title: Replace a column of data with another column from another table
body: <p>I would like to replace a column of data in a table.</p>
  
  <p>TableA<br>
  Uid  - int<br>
  AnotherUid   - int</p>
  
  <p>TableB<br>
  Uid  - int</p>
  
  <p>TableA.uid = Table.B uid 
  And I am trying to replace the TableB.Uid with TableA.AnotherUid</p>
  
  <pre><code>Select * from TableB a,  TableA b  where a.uid=b.uid 
  update TableB set a.uid=b.AnotherUid
  </code></pre>
  
  <p>I got a SQL syntax error from MySQL at TableB set a.uid=b.AnotherUid.</p>
  
  <p>Please kindly help.</p>