UPDATE MD_MATERIAL t1

set t1.MATERIAL_NAME_EN = (

select t.PART_NAME_EN as MATERIAL_NAME_EN from MSTDATA.MD_PART_NAME t where t1.MATERIAL_NAME = t.PART_NAME_ZH)

where exists

(select t.PART_NAME_EN as MATERIAL_NAME_EN from MSTDATA.MD_PART_NAME t where t1.MATERIAL_NAME = t.PART_NAME_ZH);