哪里错了？

[wuszh1688]

SELECT user_saving_type,SUM(user_saving_num) AS saving_num FROM user_saving WHERE user_saving.user_login_name='1212' AND 1 AND user_saving_day LIKE '2009%' AND saving_num >= 10 AND saving_num <= 100 GROUP BY user_saving_type



#1054 - Unknown column 'saving_num' in 'where clause'

[babyboyren]

这个“saving_num”名字写错了，系统不认识

[gqs2105]

顶贴~!

随便做下广告
PHP MYSQL CMS交流群88286077

[dzxccsu]

你的表中没有saving_num这个字段

[CunningBoy]

user_saving表中没有saving_num字段
可能写错了，对比数据库的表检查一下。

[phpboy]

SELECT user_saving_type,SUM(user_saving_num) AS saving_num FROM user_saving WHERE user_saving.user_login_name='1212' AND 1 AND user_saving_day LIKE '2009%' AND saving_num >= 10 AND saving_num <= 100 GROUP BY user_saving_type

后面字段用的有问题，你用的是字段别名

[Mlive]

[Quote=引用 3 楼 dzxccsu 的回复:]
你的表中没有saving_num这个字段
[/Quote]

3楼的说法是正确的，检查一下数据表吧

[wuszh1688]

应该怎么写，就是某字段的和在一定范围内被取出

[wuszh1688]

SUM(user_saving_num) AS saving_num

[程序猿之殇]

group by 算出的sum结果,就算你用了别名,也不能直接用到where子句里的.

正确的写法是用having子句.

SELECT user_saving_type,SUM(user_saving_num) AS saving_num FROM user_saving WHERE user_saving.user_login_name='1212' AND 1 AND user_saving_day LIKE '2009%' AND 
GROUP BY user_saving_type 
HAVING saving_num >= 10 and saving_num <= 100

[wuszh1688]

还是不对

[wuszh1688]

把group前的 and 去掉就对了，谢谢楼上这位

[程序猿之殇]

呵呵,复制的时候没去掉.