title: SQL Server: copy data from one column to another column?
body: <p>I have two tables with the same column <code>anomaly_id</code>. I want to copy the row of <code>anomaly_id</code> from the first table to the second table using this code</p>
  
  <pre><code>UPDATE amb.anamoly_log_update
  SET anamoly_id = t2.anomaly_id
  FROM amb.anamoly_log_update t1 
  INNER JOIN amb.anomaly_fee t2 ON t1.anamoly_id=t2.anomaly_id
  </code></pre>
  
  <p>Even after I did that it shows 0 rows affected, when there is data in <code>amb.anomaly.fee</code> (source table)</p>
  
  <p>Please help</p>
  
  <p><strong>Edit:</strong> Comment <a href="https://stackoverflow.com/a/8959781/1158170">from post</a>: I just want to copy all the <code>anamoly_id</code> from <code>amb.anamoly_fee</code> to <code>amb.anamoly_log_update</code>. My code might be nonsensical. Please do review it.</p>