title: Update Query with Join in DB2/AS400
body: <p>I'm somewhat new to DB2 on an AS400, today I managed to set the value of a single field to the wrong amount in 300k+ records, and now I need to fix it...</p>
  
  <p>I'm having a problem with the UPDATE statement:</p>
  
  <pre><code>UPDATE WHSPSLP
  SET WHSPSLP.WHS_TOT_VALUE = BUWHSPSLP.WHS_TOT_VALUE
  WHERE WHSPSLP.WHS_PSLP_NO = BUWHSPSLP.WHS_PSLP_NO
  </code></pre>
  
  <p>I'm updating the field with the correct value from a back up of the table, but I just can't get it right.</p>
  
  <p>Thanks </p>