打印报表时的SQL语句出错

[cat7035]

我有两个表，sch_tradehis,sch_shop2
sch_tradehis:
shop_id term_id settle_date amount
001 1 2002-06-01 20
001 1 2002-06-01 17
001 2 2002-06-02 67
001 2 2002-06-02 100
。。。。。


sch_shop2:
shop_id shop_name
001 一食堂
002 二食堂
。。。。。

执行
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,sch_tradehis.term_id,sch_tradehis.settle_date
总是报错，请帮我看一下！

[Lzh_lee]

nvl(sum(amount),0)，nvl是什么来的？好像不是一个函数吧？

[Backspace24]

sum 取名的错

[cat7035]

刚才打错了一点，苯苯熊你指的是这点吗？
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

[liyunsong2000]

sum 为关键词，你换一个别的

[Backspace24]

(sch_tradehis_amount),0) sum 这是什么啊。。
不能用sum啊，你试试sum1
count 也一样，不能用它们是保留字。为什么你还要做变量呢。
所以。要出错了哟