title: Update a table with values from another table
body: <p>I have a table (say,ABC) which has the following structure :</p>
  
  <pre><code> COMP_CODE    NAME    SALARY  SID1
  -------------------------------------
    NULL      Alex     42000     85
    NULL      Alex     42000     89
    NULL      Alex     42000     96
    NULL      Alex     42000    100
    NULL      Alex     42000     52
  </code></pre>
  
  <p>I want to update the _<strong>COMP_CODE</strong>_ column in the above table from value residing in another table <strong>(CC)</strong>. The matching columns among the two table is <strong><em>SID1</strong></em>. The structure of <em>CC</em> is as follows :</p>
  
  <pre><code>  COMP_CODE    SID1
  ----------------------
      0AA         85
      0AB         96
      0CD         98
      0DE         72
      0EH        100 
  </code></pre>
  
  <p>Can this achieved through a <em><strong>CURSOR</strong></em> or any other sort of method.</p>