title: How do you use an update between two tables in Oracle SQL
body: <p>Hopefully this is relatively simple.  I want to update a table in Oracle but the data being compared is between two tables.  How can I accomplish this?  I tried the following SQL but know is incorrect after trying it:</p>
  
  <pre><code>           UPDATE gm_prc
             SET gm.RETAIL_DT = '01-JAN-2000'
             from gm_prc gm, itm_prc_cmp3 itm
             where gm.sku_num = itm.SKU_NUM
             and gm.PC_NUM = itm.PC_NUM
  </code></pre>