2010年8月9日——Oracle从一个表抓取数值更新另一个表数值的语句

update sajet.g_sn_status t
set t.customer_sn=(select n.customer_sn from sajet.g_sn_travel n
where n.serial_number in ('201011647485',
'201012562676')
and n.serial_number=t.serial_number
and n.process_id='100014'
and n.customer_sn is not null
and n.customer_sn<>'N/A')
where  exists (select 1 from sajet.g_sn_travel n
where n.serial_number in ('201011647485',
'201012562676')
and n.serial_number=t.serial_number
and n.process_id='100014'
and n.customer_sn is not null
and n.customer_sn<>'N/A')