title: Copy data from one table onto another using SQL UPDATE statement
body: <pre><code>UPDATE table2 
  SET table2.col1 = table1.col1, 
  table2.col2 = table1.col2,
      table2.col3 = table2.col3,
  ...
  FROM table1, table2 
  WHERE table1.memberid = table2.memberid
  </code></pre>
  
  <p>Please help me to understand how to implement SET clause when there are 9-10 rows, and with common column name SCRIPT_ID so that script can be used again in the future to update the same table.</p>
  
  <p>Here is a snippet from the table: </p>
  
  <pre><code>____     _____________   __________________  _____     _     _____
   999     EMS02075SVC     Host Controller     15099     3     60000 
  1000     EMS02075SVC     DSM Controller      15099     1     60000 
  1001     EMS02075WEB1    Application Server   4447     1     60000
  </code></pre>