3,491
社区成员
发帖
与我相关
我的任务
分享
select t.con_id,
t.con_no,
t.con_name,
to_char(t.transact_id),
to_char(t.proc_start_time, 'yyyy-mm-dd'),
t.transact_status,
t.dishi_contract,
t.proc_id
from cu_contract_detail t
where t.transact_status in ('2', '3')
and (t.con_participant like '%,103209,%' or
t.con_participant like '%103209,%' or
t.con_participant like '%,103209%' or t.con_participant = '103209')
union
select t.con_id,
t.con_no,
t.con_name,
to_char(t.transact_id),
to_char(t.proc_start_time, 'yyyy-mm-dd'),
t.transact_status,
t.dishi_contract,
t.proc_id
from cu_contract_detail t
where t.transact_status in ('2', '3')
and t.proc_id in (select t1.proc_ins_id
from cu_back_idea t1
where t1.from_person_id = '103209')
select t.con_id,
t.con_no,
t.con_name,
to_char(t.transact_id),
to_char(t.proc_start_time, 'yyyy-mm-dd'),
t.transact_status,
t.dishi_contract,
t.proc_id
from cu_contract_detail t
where t.transact_status in ('2', '3')
and instr(t.con_participant, '103209') > 0
and exists (select 1
from cu_back_idea t1
where t1.from_person_id = '103209'
and t1.proc_ins_id = t.proc_id)
select t.con_id,
t.con_no,
t.con_name,
to_char(t.transact_id),
to_char(t.proc_start_time, 'yyyy-mm-dd'),
t.transact_status,
t.dishi_contract,
t.proc_id
from cu_contract_detail t
where t.transact_status in ('2', '3')
and instr(t.con_participant, '103209') > 0
and t.proc_id in (select t1.proc_ins_id
from cu_back_idea t1
where t1.from_person_id = '103209')