update 表1 d set d.字段1=(select t.字段2 from 表2 t where d.字段3=t.字段4 and t.字段2 is not null)
where exists(select t.字段2 from 表2 t where d.字段3=t.字段4 and t.字段2 is not null)
where exists(select t.字段2 from 表2 t where d.字段3=t.字段4 and t.字段2 is not null)