MySQL Query:select u.realname,u.dpcode,u.username,sum(aa.pv),sum(aa.price) as price_or from dg_users as u inner join dg_orders as aa on (u.username=aa.dianpu_flag ) and u.rank>=3 and aa.zftime>=1315195740 and aa.shtime<=1316142599 and aa.state>=3 and sum(aa.price)>=50.00 group by aa.dianpu_flag order by 5 desc
MySQL Error:Invalid use of group function
MySQL Errno:1111
Message:MySQL Query Error sum(aa.price)>=50.00 这个写错、 不知道该怎么写?
MySQL Error:Invalid use of group function
MySQL Errno:1111
Message:MySQL Query Error sum(aa.price)>=50.00 这个写错、 不知道该怎么写?
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货