又学一招,原来还可以这么写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学的太基础了,还要再努力