请尝试：

INSERT INTO `table1` (`C`,`D`,`E`,`G`,`J`) VALUES
     (SELECT `C`,`D`,`E`,`G`,`J` FROM `table2` WHERE 
     `table1`.`A` = `table2`.`A`);

已修改::

如果你只需要更新::

If you only need to update then ::

update table1 
set 
table1.C=table2.C, 
table1.D=table2.D,
table1.E=table2.E, 
table1.G=table2.G,
table1.J=table2.J
WHERE 
table1.A = table2.A;