这个SQL怎么改啊?在线等待!
SELECT sum(nvl(a.retail_money,0)),sum(nvl(a.trade_price,0)*nvl(a.amount,0)*nvl(a.account,0)),sum(nvl(a.balance_money,0))
FROM t_ps_arrive_attached a , t_ps_arrive_main b ,t_ps_duginf c
WHERE a.in_no = b.in_no
AND a.affirm_date >= :ld_start
AND a.affirm_date <= :ld_end
AND a.drug_no = c.drug_no
AND b.businessman like :ls_code_factory
AND c.drug_kind = :ls_code
AND a.status = '1'
AND (a.save_status = '' or a.save_status is null);
a,b是主从表,in_no是主表关键字,当主表数据对应从表多条记录查询有问题。
别外两个表数据量也比较大,速度也要考虑一下。
各位高手这个怎么改?