title: How to copy some column from a table to another mysql
body: <p>i have two tables like:</p>
  
  <p>table 1:</p>
  
  <pre><code>|A|B|C|D|E|F|G|H|I|J|
  </code></pre>
  
  <p>table 2:</p>
  
  <pre><code>|A|C|D|E|G|H|J|K|L|M|N|O|P|
  </code></pre>
  
  <p>i have to copy some columns from table 2 to table 1.
  What i try is:</p>
  
  <pre><code>INSERT INTO `table 1` (`C`,`D`,`E`,`G`,`J`)
       SELECT `C`,`D`,`E`,`G`,`J` FROM `table 2` WHERE 
       `table 1`.`A` = `table 2`.`A`;
  </code></pre>
  
  <p>but it result :</p>
  
  <pre><code>#1054 - Unknown column 'table 1.A' in 'where clause'
  </code></pre>
  
  <p>where is the error? can someone help me? </p>
  
  <p>MY ERROR IS THAT I DON'T HAVE TO INSERT NEW ROWS, BUT UPDATE THE ROWS THAT MATCH THE COLUMN A... in which way i have to edit my query? thanks!</p>