分类: PHP
2013-03-05 15:29:17
Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause
select user,type,number,sum(price) as aa from reim where number=2 and type=1 and user='aa'
Filename: C:\wamp\www\itsod1\system\database\DB_driver.php
解决方法:加上group by 。查询统计汇总在后面一定要有group by