Insert Into
TableName_1
(column_1, column_2......)
Values
select column_1, column_2..... form TableName_2
Update
set tablename_1.column_1=tablename_2.column_1
From
tablename_1 Inner Join tablename_2 on tablename_1.column=tablename_2.column