Insert Into select与Update select

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

 

update <TableName1> set <column1>= (select  (<column1>)  from <TableName2>  where TableName1.<column2> =  TableName2.<column2>)