SQLServer修改表字段时进行表连接

update A set A.XXX='XXXX'
from TableA  A
inner join TableB B on B.XX=A.XX
where XXXXX