更新2干传输设备

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
)