update table_1 inner join table_2 on table_1.id = table_2.id_table_1
set table_1.field_1=table_2.field_2;