select a.investorname,
a.account_no,
a.opendate,
a.mobile,
a.email,
b.mon_month,
b.mon_award,
b.mon_minus,
b.mon_order,
b.mon_share,
b.mon_balance,
b.mon_lastbalance,
c.SumBalance+c.sc_amount-c.orderamount as SumNum
from sc_account a, sc_month b,
(SELECT b.SumBalance, c.sc_amount, e.orderamount
FROM sc_account a,
(select nvl(sum(sc_amount), 0) as sc_amount
from sc_adjust
where account_no = '481038505028') c,
(select nvl(sum(orderamount * changenum), 0) as o
rderamount
from sc_order
where account_no = '481038505028') e,
(select nvl(sum(score), 0) as SumBalance
from sc_detail
where account_no = '481038505028') b
WHERE a.account_no = '481038505028') c
where a.account_no = '481038505028' and b.account_no = '4810385
05028' and
b.mon_month between to_date('2007-01', 'yyyy-mm') and
add_months(to_date('2007-10', 'yyyy-mm'), 1) 作者: woailiming 时间: 2007-11-1 09:46