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
)
扫一扫
3828
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
