mysql 複合キーのupdate

UPDATE table1
  INNER JOIN table2
  ON table1.`keyA`=table2.`keyA` AND table1.`keyB`=table2.`keyB`
  SET table1.`値`=table2.`値`


keyA,keyBをキーとして
table1の値をtable2の値に変換