insert into 和Update select

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>)