请教一条SQL语句的写法
更新 A表所有记录的 name字段 = B表的name + cname
条件是当A表.name = B表.name时

谢谢

[解决办法]
UPDATE a SET name = b.name + b.cname
FROM tableA as a
INNER JOIN tableB as b on a.name = b.name