一、
update a set a.name=b.name1 from a,b where a.id=b.id
二、
update table1 set a.status = b.status from table1 a inner join table2 b on a.idl = b.idl
本文共 219 字，大约阅读时间需要 1 分钟。
update a set a.name=b.name1 from a,b where a.id=b.id
二、
update table1 set a.status = b.status from table1 a inner join table2 b on a.idl = b.idl
转载于:https://www.cnblogs.com/m0488/p/8567016.html