update t_material_info m set m.mcode = (select t.mcode from t_test_material t where m.id = t.id)
where m.mcode is null
and exists (
select t.mcode from t_test_material t where m.id = t.id
)
where m.mcode is null
and exists (
select t.mcode from t_test_material t where m.id = t.id
)