title: Update single data row from table to another
body: <p>How can I <strong>update a complete data row by using a data row from another table</strong>.</p>
  
  <p>Example:</p>
  
  <pre><code>Table A
  
  ID   |   NAME    |   ...   |
  ----------------------------
   1   |   Test    |   ...   |
   2   |   Test2   |   ...   |
  
  
  
  Table B
  
  ID   |   NAME    |   ...   |
  ----------------------------
   1   |   Test97  |   ...   |
  </code></pre>
  
  <p>So I want to copy the content of a single row of Table B to Table A and override existing values. I do not want to name all columns. The contents of table A and B are redundant.</p>
  
  <p><strong>Summarize:</strong>
  I want an equivalent to the following INSERT Statement as an UPDATE Statement:</p>
  
  <pre><code>INSERT INTO destTable 
  VALUES  (SELECT * FROM TABLE2)
  FROM srcTable 
  </code></pre>
  
  <p>Any hint, even telling me that its not possible, is very appricated.</p>