Copy data from one table onto another table

Copy data from one table onto another table 

UPDATE Table2 
SET Table2 .col1 = Table1.col1, 
Table2 .col2 = Table1.col2,
    Table2 .col3 = Table1.col3,
...
FROM Table1, Table2
WHERE Table1.id = Table12.id