update a
set a.supervisorFullName = b.supervisorFullName
from sys_orgmenber a join sys_user b on a.member = b.fullname

------解决方案--------------------
SQL code


update sys_orgmenber set supervisorFullName =  b.supervisorFullName from sys_orgmenber a inner join sys_user b on a.member = b.fullname

------解决方案--------------------
update sys_orgmenber set supervisorFullName =  n.supervisorFullName
from sys_orgmenber m , sys_user n
where m.member = n.fullname


------解决方案--------------------
SQL code
update
 a
set
 supervisorFullName = b.supervisorFullName
from
 sys_orgmenber a join sys_user b on a.member = b.fullname

------解决方案--------------------
	
	update sys_orgmenber set supervisorFullName = a.supervisorFullName
	from sys_user as a
	where a.fullname=sys_orgmenber.member

------解决方案--------------------
SQL code
update sys_orgmenber set supervisorFullName = A.supervisorFullName
from sys_orgmenber A , sys_user B
where A.member = B.fullname

------解决方案--------------------
update sys_orgmenber set supervisorFullName = n.supervisorFullName
from sys_orgmenber m , sys_user n
where m.member = n.fullname


------解决方案--------------------
SQL codeupdate
  a
set
  supervisorFullName = b.supervisorFullName
from
  sys_orgmenber a join sys_user b on a.member = b.fullname  


------解决方案--------------------
update sys_orgmenber set sys_orgmenber.supervisorFullName=sys_user.supervisorFullName

from sys_user where sys_orgmenber.member=sys_user.fullname

本人也是新手，希望此帖有所指导。