Update data in two table using join

update table1 set table1.column=table2.column from table1 join table2 on table1.column=table2.column