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

sql 联合查询并更新,布布扣,bubuko.com

原文：http://www.cnblogs.com/taomylife/p/3579853.html