update RMS_TRANSCIR_LOCAL
set SOURCE_NE=REMOTE_TRANS_EQU,REMOTE_TRANS_EQU=SOURCE_NE,SOURCE_TRANS_PORT=REMOTE_TRANS_PORT,REMOTE_TRANS_PORT=SOURCE_TRANS_PORT
where 
SOURCE_NE not in (select OLD_NAME from rms_transne_local where city_id=818 and IS_CENTERNE=1)
and 
REMOTE_TRANS_EQU in (select OLD_NAME from rms_transne_local where city_id=818 and IS_CENTERNE=1)