title: not getting the right results when I update table from another table
body: <p>I am trying to use update / where  in a sql query to match ID's and then pull the data associated into my table. </p>
  
  <p>I am running into a  problem.</p>
  
  <p>First, when I run </p>
  
  <pre><code>UPDATE table1
  SET table1.column = table2.column
  FROM table2
  WHERE table1.columnB = table2.columnB
  </code></pre>
  
  <p>it works on some and not others. its like 50/50 success. Some of the results are completely wrong and I don't know why.</p>
  
  <p>Thanks for the help.</p>