title: Oracle SQL: Update a table with data from another table
body: <p>Table 1:</p>
  
  <pre><code>id    name    desc
  -----------------------
  1     a       abc
  2     b       def
  3     c       adf
  </code></pre>
  
  <p>Table 2:</p>
  
  <pre><code>id    name    desc
  -----------------------
  1     x       123
  2     y       345
  </code></pre>
  
  <p>In oracle SQL, how do I run an <strong>sql update</strong> query that can update Table 1 with Table 2's <code>name</code> and <code>desc</code> using the same <code>id</code>? So the end result I would get is</p>
  
  <p>Table 1:</p>
  
  <pre><code>id    name    desc
  -----------------------
  1     x       123
  2     y       345
  3     c       adf
  </code></pre>
  
  <p>Question is taken from <a href="https://stackoverflow.com/questions/5036918/sql-update-query-with-data-from-another-table">update one table with data from another</a>, but specifically for oracle SQL.</p>