title: Oracle database, update data from 1 table to another
body: <p>I have 2 tables in an oracle 12c database and i want to update from 1 table to the next.</p>
  <p>Table 1 (EMBLEMTEMPLATE et):<br />
  et.emblemtemplate_id, et.customer_id, et.code</p>
  <p>Table 2 (PRODUCTLISTPERCUSTOMER):<br />
  plpc.productlistpercustomer_id, plpc.customer_id, plpc.emblemtemplate_id,</p>
  <p>What i am trying to do:</p>
  <ol>
  <li>Check with all the plpc.productlistpercustomer if there is a plpc.emblemtemplate_id filled, if not this need to be updated.</li>
  <li>plpc.emblemtemplate_id needs to be updated with et.emblemtemplate_id where et.code  = &quot;999991&quot;</li>
  <li>The tables must be joined on CUSTOMER_ID</li>
  </ol>
  <p>i created a select:</p>
  <pre><code>select plpc.customer_id,
    plpc.productlistpercustomer_id,
    plpc.emblemtemplate_id,
    et.customer_id,
    et.emblemtemplate_id,
    et.code
    from productlistpercustomer plpc
    inner join emblemtemplate et
    on et.customer_id = plpc.customer_id
    where et.code = '999991'
  </code></pre>
  <p>Can somebody help me to translate this to a sql update script?</p>
  <p>Thanks!</p>
  <p><a href="https://i.stack.imgur.com/CSJ9q.png" rel="nofollow noreferrer">Visual of what i want to do</a></p>