s******d 发帖数: 901 | 1 谢谢了。
select available.company_id, available.currency, available.sum, pending_paid
.sum
from (
(select company_id, currency, sum(value) as sum from
member_transactions where status ='A'
group by currency, company_id) as available
inner join
(select company_id, currency, sum(value) as sum from
member_transactions where status ='P'
group by currency, company_id) as pending_paid
on available.company_id=pending_paid.company_id
and available | s******d 发帖数: 901 | | B*****g 发帖数: 34098 | 3 select company_id, currency, sum(DECODE(status, 'A', value, 0)) as A_sum , s
um(DECODE(status, 'P', value, 0)) as p_sum
from member_transactions
where status ='A' OR status ='P'
group by currency, company_id
paid
【在 s******d 的大作中提到】![](/moin_static193/solenoid/img/up.png) : 谢谢了。 : select available.company_id, available.currency, available.sum, pending_paid : .sum : from ( : (select company_id, currency, sum(value) as sum from : member_transactions where status ='A' : group by currency, company_id) as available : inner join : (select company_id, currency, sum(value) as sum from : member_transactions where status ='P'
|
|