update rms_transne_2gx
set (ZH_LABEL,NE_CODE,RELATED_EQUIPROOM,RELATED_RACK,SERIAL,PRODUCT,STATUS,CITY_ID,ENTER_TIME,CUT_TIME)=
(
select rms_transne.ZH_LABEL,rms_transne.NE_CODE,rms_transne.RELATED_EQUIPROOM,rms_transne.RELATED_RACK,rms_transne.SERIAL,rms_transne.PRODUCT,rms_transne.STATUS,rms_transne.CITY_ID,ENTER_TIME,CUT_TIME
from rms_transne
where rms_transne.OLD_NAME=rms_transne_2gx.OLD_NAME
AND rms_transne.RELATED_EMS=rms_transne_2gx.EMS_NAME
and rms_transne.STATEFLAG=0
)
WHERE EXISTS(
select 1
from rms_transne
where OLD_NAME=rms_transne_2gx.OLD_NAME
AND RELATED_EMS=rms_transne_2gx.EMS_NAME
and rms_transne.STATEFLAG=0
)
更新2干传输设备
最新推荐文章于 2022-11-21 17:27:56 发布