title: How to copy another table's record
body: <p>I have table x, y</p>
  
  <p>Table x</p>
  
  <pre><code>Id       name.       wage    
  1.       A.          10
  2.       B.          12
  3.       C.          13
  </code></pre>
  
  <p>Table y</p>
  
  <pre><code>Id.      Bonus    
  1.       5
  3.       6
  </code></pre>
  
  <p>I want to create another table but with the records of table x but in wage i want to add it with bonus so the output like this</p>
  
  <pre><code>Id       name.       wagebonus    
  1.       A.          15    
  2.       B.          12    
  3.       C.          19
  </code></pre>
  
  <p>I tried </p>
  
  <pre><code>insert into newtable 
  select id, name, wage+bonus from x, y
  </code></pre>
  
  <p>But failed</p>