刚才打错了一点,苯苯熊你指的是这点吗? 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(sch_tradehis_amount) count,nvl(sum(sch_tradehis_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,sch_tradehis.term_id,sch_tradehis.settle_date
sum 为关键词,你换一个别的
(sch_tradehis_amount),0) sum 这是什么啊。。 不能用sum啊,你试试sum1 count 也一样,不能用它们是保留字。为什么你还要做变量呢。 所以。要出错了哟
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(sch_tradehis_amount) count,nvl(sum(sch_tradehis_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,sch_tradehis.term_id,sch_tradehis.settle_date
不能用sum啊,你试试sum1
count 也一样,不能用它们是保留字。为什么你还要做变量呢。
所以。要出错了哟