UPDATE &acct_item_t t SET exch_id=(SELECT exch_id FROM &serv_addr a WHERE a.serv_id=t.serv_id) WHERE t.exch_id='0' AND t.serv_id IN (SELECT serv_id FROM &serv_addr)UPDATE &acct_item_t SET exch_id=1 WHERE t.exch_id='0' AND t.serv_id NOT IN (SELECT serv_id FROM &serv_addr)
SET exch_id=(SELECT exch_id FROM &serv_addr a WHERE a.serv_id=t.serv_id)
WHERE t.exch_id='0'
AND t.serv_id IN (SELECT serv_id FROM &serv_addr)UPDATE &acct_item_t
SET exch_id=1
WHERE t.exch_id='0'
AND t.serv_id NOT IN (SELECT serv_id FROM &serv_addr)