本地网neport的乱七八糟

SELECT count(*) FROM RMS_NEPORT_2GX port
WHERE exists (
    SELECT 1 FROM RMS_TRANSCIR_USER usr,RMS_NEPORT_2GX port
        where usr.SOURCE_NE= port.SOURCE_NE_COL  
         and usr.SOURCE_TRANS_PORT = port.OLD_NAME
)




SELECT count(*) FROM RMS_NEPORT_2GX port
update RMS_NEPORT_2GX port
set port.PORT_STATUS_USER='在用'
where exists(
  select 1
  from RMS_TRANSCIR_USER
  where REMOTE_TRANS_PORT=port.OLD_NAME
       and REMOTE_TRANS_EQU=port.SOURCE_NE_COL
)



select count(*) from RMS_NEPORT_2GX
where PORT_STATUS_USER ='在用'