update b set b.name=a.name
from table1 a inner join table2 b on b.id=a.id
where a.id='1'
通过A表数据更新B表数据
于 2022-10-10 10:39:47 首次发布
update b set b.name=a.name
from table1 a inner join table2 b on b.id=a.id
where a.id='1'