MySQL update column in one table with data from another table

update table1 t1
  join table2 t2 on t2.field = t1.field
set t1.field1 = t2.matchingfield
where t1.whatever = t2.whatever