哪位朋友帮我看一下.这个查询语句哪里写错了..

[xudongdong1981]

select carrent_carnum,carrent_customer,carrent_renttime,carrent_realreturntime,carrent_money,carrent_kilo,carrent_rentprice,sum(carrent_rentmoney) as carrent_rentmoney,sum(carrent_othertotal) as carrent_othertotal,sum(carrent_total) as carrent_total from carrent where carrent_renttime like '%2006-4-26 %' and carrent_realreturntime like '%2006-4-29 %' and carrent_returncar=true group by carrent_carnum
执行老是出错错误..晕了..
我是要按carrent_carnum 分组统计
提示:
Microsoft JET Database Engine 错误 '80040e21'
试图执行的查询中不包含作为合计函数一部分的特定表达式 'carrent_customer' 。

[xudongdong1981]

哪位大哥..指点小弟弟一下...谢谢啦

[cqq]

carrent_customer,carrent_renttime,carrent_realreturntime ......

你这些都没有分组， 怎么能选择出来呢

看一看 group by 的语法

SELECT pub_id, total = SUM(ytd_sales) //select 的要么是分组的，要么是聚合函数
FROM titles
GROUP BY pub_id

[xudongdong1981]

那要怎么写呀??...兄弟...

[xudongdong1981]

哦...我理解你的意思了..谢谢你提醒....谢谢!

[icefire988]

select carrent_carnum,carrent_customer,carrent_renttime,carrent_realreturntime,carrent_money,
carrent_kilo,carrent_rentprice,sum(carrent_rentmoney) as carrent_rentmoney,sum(carrent_othertotal)
as carrent_othertotal,sum(carrent_total) as carrent_total from carrent where carrent_renttime
like '%2006-4-26 %' and carrent_realreturntime like '%2006-4-29 %' and carrent_returncar=true
and carrent_carnum in ( select carrent_carnu group by carrent_carnumm where carrent_renttime
like '%2006-4-26 %' and carrent_realreturntime like '%2006-4-29 %' and carrent_returncar=true)

[icefire988]

上面发错了
select carrent_carnum,carrent_customer,carrent_renttime,carrent_realreturntime,carrent_money,carrent_kilo,carrent_rentprice,sum(carrent_rentmoney) as carrent_rentmoney,sum(carrent_othertotal) as carrent_othertotal,sum(carrent_total) as carrent_total from carrent where carrent_renttime like '%2006-4-26 %' and carrent_realreturntime like '%2006-4-29 %' and carrent_returncar=true and carrent_carnum in ( select carrent_carnu from carrent where carrent_renttime like '%2006-4-26 %' and carrent_realreturntime like '%2006-4-29 %' and carrent_returncar=true group by carrent_carnumm)

[icefire988]

上面发错了
select carrent_carnum,carrent_customer,carrent_renttime,carrent_realreturntime,carrent_money,carrent_kilo,carrent_rentprice,sum(carrent_rentmoney) as carrent_rentmoney,sum(carrent_othertotal) as carrent_othertotal,sum(carrent_total) as carrent_total from carrent where carrent_renttime like '%2006-4-26 %' and carrent_realreturntime like '%2006-4-29 %' and carrent_returncar=true and carrent_carnum in ( select carrent_carnu from carrent where carrent_renttime like '%2006-4-26 %' and carrent_realreturntime like '%2006-4-29 %' and carrent_returncar=true group by carrent_carnumm)

[zhangjingcheng]

顶楼上！

[icefire988]

上面发错了
select carrent_carnum,carrent_customer,carrent_renttime,carrent_realreturntime,carrent_money,carrent_kilo,carrent_rentprice,sum(carrent_rentmoney) as carrent_rentmoney,sum(carrent_othertotal) as carrent_othertotal,sum(carrent_total) as carrent_total from carrent where carrent_renttime like '%2006-4-26 %' and carrent_realreturntime like '%2006-4-29 %' and carrent_returncar=true and carrent_carnum in ( select carrent_carnu from carrent where carrent_renttime like '%2006-4-26 %' and carrent_realreturntime like '%2006-4-29 %' and carrent_returncar=true group by carrent_carnumm)

[icefire988]

晕，断网前发出来了。

[xudongdong1981]

晕...还是一样的提示...不知道哪里错了...

[xudongdong1981]

哪位再帮帮我...调试好久...唉..对SQL语句不是很精通..痛苦ING~~