请教一条SQL语句的写法

[bigelf]

更新 A表所有记录的 name字段 = B表的name + cname
条件是当A表.name = B表.name时

谢谢

[hellowork]

UPDATE a SET name = b.name + b.cname
FROM tableA as a
INNER JOIN tableB as b on a.name = b.name

[bigelf]

谢谢