更新2干传输设备

ztbsuper

于 2010-07-20 17:24:09 发布

阅读量151

点赞数

分类专栏：四川移动oss 文章标签： Rack SQL

本文链接：https://blog.csdn.net/ztbsuper/article/details/83672342

版权

四川移动oss 专栏收录该内容

10 篇文章 0 订阅

订阅专栏


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
)