update table1 set uName = t2.uName from table1 t1 inner join table2 t2 on t1.uID = t2.uID
SQL中使用update inner join
最新推荐文章于 2024-05-06 20:08:09 发布
update table1 set uName = t2.uName from table1 t1 inner join table2 t2 on t1.uID = t2.uID