select *
from T21_EAP_ACC_PUNISH_INFO t1, t21_eap_acc_base_info t2
where t1.accbaseid = t2.accbaseid
and t1.state = '02'
and t2.state = '03'
and t1.relievetime is not null
and t1.punishtimelimit is null
and t2.happenorgcode = '02'
and t1.relievetime <= to_char(sysdate, 'yyyy-mm-dd')
union all
select *
from T21_EAP_ACC_PUNISH_INFO t1, t21_eap_acc_base_info t2
where t1.accbaseid = t2.accbaseid
and t1.state = '02'
and t2.state = '03'
and t1.relievetime is null
and t1.punishtimelimit is not null
and t2.happenorgcode = '02'
and to_char(add_months(sysdate,
decode(t1.punishtimelimit,
'半年',
-6,
'一年',
-12,
'二年',
-24,
99)),
'yyyy-mm-dd') >= t1.punishtime
union all
select *
from T21_EAP_ACC_PUNISH_INFO t1, t21_eap_acc_base_info t2
where t1.accbaseid = t2.accbaseid
and t1.state = '02'
and t2.state = '03'
and t1.relievetime is null
and t1.punishtimelimit is null
and t1.insidepunishtype = '01'
and t2.happenorgcode ='02'
and to_char(add_months(sysdate,
case
when t1.punishway = '01' then
-6
when t1.punishway in ('02', '03', '04') then
-12
when t1.punishway = '05' then
-24
when t1.punishway = '06' then
-24
else
99
end),
'yyyy-mm-dd') >= t1.punishtime
各位大神，请问这一条拼接sql咋样才能写成一条SQL,求指导