请教一条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
