select sch_tradehis.shop_id shop_id,sch_tradehis.term_id term_id,sch_tradehis.settle_date settle_date, sch_shop2.shop_name shop_name,count(amount) count,nvl(sum(amount),0) sum from sch_shop2,sch_tradehis where sch_tradehis.shop_id=sch_shop2.shop_id and sch_tradehis.settle_date between '2002-06-02' and '2002-07-01' group by sch_tradehis.shop_id shop_id,sch_tradehis.term_id term_id,sch_tradehis.settle_date settle_date,sch_shop2.shop_name shop_name
select sch_tradehis.shop_id, sch_tradehis.term_id, sch_tradehis.settle_date, sch_shop2.shop_name, count(amount) count_amount, nvl(sum(amount),0) sum_amount from sch_shop2,sch_tradehis where sch_tradehis.shop_id=sch_shop2.shop_id and sch_tradehis.settle_date between '2002-06-02' and '2002-07-01' group by sch_tradehis.shop_id, sch_tradehis.term_id, sch_tradehis.settle_date, sch_shop2.shop_name;
sch_shop2.shop_name shop_name,count(amount) count,nvl(sum(amount),0) sum from sch_shop2,sch_tradehis
where
sch_tradehis.shop_id=sch_shop2.shop_id and sch_tradehis.settle_date between '2002-06-02' and '2002-07-01' group by sch_tradehis.shop_id shop_id,sch_tradehis.term_id term_id,sch_tradehis.settle_date settle_date,sch_shop2.shop_name shop_name
sch_tradehis.term_id,
sch_tradehis.settle_date,
sch_shop2.shop_name,
count(amount) count_amount,
nvl(sum(amount),0) sum_amount
from sch_shop2,sch_tradehis
where sch_tradehis.shop_id=sch_shop2.shop_id
and sch_tradehis.settle_date between '2002-06-02' and '2002-07-01'
group by sch_tradehis.shop_id,
sch_tradehis.term_id,
sch_tradehis.settle_date,
sch_shop2.shop_name;