よく忘れちゃうので。 update table1 inner join table2 on table1.column1 = table2.column2 set table1.column2 = table2.column2;