sql两个表联合更新

update TableA set id=TableB.id from TableA,TableB where TableA.name=TableB.name