Question

将数据库A表里面的name字段 用B表里面的name替换 SQl语句怎么写

Answer 1

update a set a.name = b.name from a,b where a.[关联字段] = b.[关联字段]

Answer 2

你给先找出这两个表的关联字段
update A set name = B.name from A,B where A.字段1=B.字段2