title: How do I insert rows from another table and update at the same time?
body: <p>Table A:</p>
  
  <pre><code>A|B|C|Version
  
  1|2|3|1
  
  1|2|3|2
  </code></pre>
  
  <p>I want table B to be </p>
  
  <pre><code>A|B|C|Version
  
  1|2|3|2
  </code></pre>
  
  <p>Every row is the same as A except Version is increased by 1.
  Let's say I only want to copy the rows from table A where version=1. 
  How do I do that?</p>