又学一招，原来还可以这么写sql语句：
update 表1 set 表1.字段1=表2.字段1 from 表1 inner join 表2 on 表1.字段2=表2.字段2
update applypayment set applypayment.fullName=receive.openName
from applypayment inner join receive
on ( receive.name =applypayment.fullName and receive.name !=receive.openName)
以前的sql学的太基础了，还要再努力
转载于:https://www.cnblogs.com/n666/archive/2010/09/08/2190891.html
