17,377
社区成员
发帖
与我相关
我的任务
分享
select t1.cnt,t1.current_balance+t2.current_balance as balance_0 from(select cnt,current_balance,rownum as rn from(select count(*) as cnt,sum(a.current_balance) as current_balance from a)t1 left join(select current_balance,rownum as rn from (select sum(f.current_balance) as current_balance from f))t2 on t1.rn=t2.rn
select t1.cnt,t1.current_balance+t2.current_balance as balance_0
from (select count(*) as cnt, sum(a.current_balance) as current_balance, rownum as rn from a) t1,
left join (select sum(f.current_balance) as current_balance,rownum as rn total_f from f) t2 on t1.rn = t2.rn
select t1.cnt,t1.total_a+t2.total_f as total_all
from (select count(*) as cnt, sum(a.资金) as total_a, rownum as rn from a) t1,
left join (select sum(f.资金) as,rownum as rn total_f from f) t2 on t1.rn = t2.rn