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
原文：http://www.cnblogs.com/taomylife/p/3579853.html