select RONO,OverdueDay from
(select RONO,
case when (select sum(Amount) as Ccount from EAM_Charge_Detail where ChargeType<>7012785 and H.BIZDATE<=bizdate)
- (select CAV_amount from V_HX07_REPORT_RECEIVE_NEW t1
where t1.receivedate<=H.bizdate) > 0 then to_number(sysdate-bizdate) else 0 end as OverdueDay
from (
select RoNo,bizdate from
(select ORDERNO AS RONO,bizdate from EAM_Charge_Detail
union
select RONO,receivedate as bizdate from V_HX07_REPORT_RECEIVE_NEW)
order by bizdate desc
) H );
新手菜鸟求帮助。两张表联合起来大概有一千多万条数据,查询不出数据来 显示一直在执行,是不是我哪里写错了 求大神帮忙看看哪里不对。