sql 联合查询并更新


update sales
set sales.adminId = t.adminId
from (select a.adminId,a.realName from sales ,admin_administrators as a where sales.salesName = a.realName and a.adminId like '2%') as t
where sales.salesName = t.realName

【推广】 免费学中医，健康全家人
原文地址：https://www.cnblogs.com/taomylife/p/3579853.html