inner join しながら update - uyeeeki uyeeeki★web

inner join しながら update

update tableA as a
inner join tableB as b on a.id = b.id
set a.cellname1 = hoge
where b.cellname2 = 'hogehoge';