欢迎进入oracle社区论坛，与200万技术人员互动交流 >>进入 select 1 upload, 0 shengji, mr.busi_id, master.person_id, master.acnt_id, master.id_num, master.name, master.sex, mr.migrt_out_region, mr.out_opera_time, mr.out_opera_id, mr.in_opera_t
欢迎进入oracle社区论坛，与200万技术人员互动交流 >>进入
select 1 upload,
0 shengji,
mr.busi_id,
master.person_id,
master.acnt_id,
master.id_num,
master.name,
master.sex,
mr.migrt_out_region,
mr.out_opera_time,
mr.out_opera_id,
mr.in_opera_time,
mr.migrate_state,
mr.migrt_in_region,
case
when mr.migrt_in_region is null then
'未选择'
else
arc.region_name
end as migrt_in_region_name
from adpm_migrate_cpa master, adpm_migrate_info mr
left join adpm_region_code arc on mr.migrt_in_region = arc.region_code
where master.person_id = mr.person_id
and (mr.migrate_state = '10' or mr.migrate_state = '20' or
mr.migrate_state = '60');
select 1 upload,
0 shengji,
mr.busi_id,
master.person_id,
master.acnt_id,
master.id_num,
master.name,
master.sex,
mr.migrt_out_region,
mr.out_opera_time,
mr.out_opera_id,
mr.in_opera_time,
mr.migrate_state,
mr.migrt_in_region,
case
when mr.migrt_in_region is null then
'未选择'
else
arc.region_name
end as migrt_in_region_name
from adpm_migrate_cpa master, adpm_migrate_info mr, adpm_region_code arc
where master.person_id = mr.person_id
and (mr.migrate_state = '10' or mr.migrate_state = '20' or
mr.migrate_state = '60')
and mr.migrt_in_region = arc.region_code(+);