SELECT name,tele,COUNT(pric) as countinfo,SUM(pric) as allpric from orderinfo,userwhere user.uid=orderinfo.uidGROUP BY user.teleORDER BY allpric DESC;
GROUP BY user.tele , user.name 或者SELECT name...中把name去掉。
报错信息帖一下?我这边模拟没报错哦