oracle 请问一下,这一条拼接的sql怎么写成一条SQL(急!!!)

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,求指导

1个回答

Csdn user default icon
上传中...
上传图片
插入图片
抄袭、复制答案,以达到刷声望分或其他目的的行为,在CSDN问答是严格禁止的,一经发现立刻封号。是时候展现真正的技术了!
立即提问
相关内容推荐