insert into <TableName1> (<column1>,<column2>)
select <column1>,<column2> from <TableName2> where column1=1
update <TableName1> set <column1,column2>= (select (<column1>,column2) from <TableName2> where TableName1.<column2> = TableName2.<column2>)