带条件进行更新关联:
update 表1 set 字段=
(select 字段
from 表2
where 表2.user_fullname = 表1.VISITDOCTOR and length(表1.visitdoctorcode) < 30
and 表1.VISITDOCTORCODE = VISITDOCTOR and 表2.teamid=表1.Operunitcode)
where
exists(
select 1
from 表2
where 表2.user_fullname = 表1.VISITDOCTOR and length(表1.visitdoctorcode) < 30
and 表1.VISITDOCTORCODE = VISITDOCTOR and 表2.teamid=表1.Operunitcode)