求助 那位高手知道SQLException: Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP B

[yinpan527]

出错页面信息：
Page error,SQL: SELECT count(*)c_InsertUser, Csc_Activity1, Csc_Activity2, Cst_State FROM (SELECT * FROM (SELECT Csc_InsertUser, sum( Csc_Activity1 ) AS Csc_Activity1, sum( Csc_Activity2 ) AS Csc_Activity2 FROM (SELECT Csc_InsertUser , If( Csc_Activity = '￥?电话', 1, 0) AS Csc_Activity1, If( Csc_Activity = '??访', 1, 0 ) AS Csc_Activity2 FROM tcustomercontact where Csc_InsertUser='erp' ) AS aaa GROUP BY Csc_InsertUser) AS ddd LEFT JOIN (SELECT * FROM (SELECT Cst_Staff, sum( Cst_State ) AS Cst_State FROM (SELECT Cst_Staff, if( Cst_State = 'Completed', 1, 0 ) AS Cst_State FROM tcustomer WHERE Cst_Type = 'customer' AND trim( Cst_Staff ) <> '') AS bbb GROUP BY Cst_Staff) AS ccc) AS eee ON eee.Cst_Staff = ddd.Csc_InsertUser) AS fffjava.sql.SQLException: Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause
jsp页面中的sql语句：
sql="SELECT Csc_InsertUser, Csc_Activity1, Csc_Activity2, Cst_State FROM (SELECT * FROM (SELECT Csc_InsertUser, sum( Csc_Activity1 ) AS Csc_Activity1, sum( Csc_Activity2 ) AS Csc_Activity2 FROM (SELECT Csc_InsertUser , If( Csc_Activity = '"+active[0]+"', 1, 0 ) AS Csc_Activity1, If( Csc_Activity = '"+active[1]+"', 1, 0 ) AS Csc_Activity2 FROM tcustomercontact ) AS aaa GROUP BY Csc_InsertUser) AS ddd LEFT JOIN (SELECT * FROM (SELECT Cst_Staff, sum( Cst_State ) AS Cst_State FROM (SELECT Cst_Staff, if( Cst_State = 'Completed', 1, 0 ) AS Cst_State FROM tcustomer WHERE Cst_Type = 'customer' AND trim( Cst_Staff ) <> '') AS bbb GROUP BY Cst_Staff) AS ccc) AS eee ON eee.Cst_Staff = ddd.Csc_InsertUser) AS fff";
sql语句写的比较复杂请各位大侠耐心看完！

[zhj92lxs]

哦

[liguangwen86]

帮顶一下

[yinpan527]

问题解决了，最后需要分组，花了1天时间。其实要是多尝试几次很快就可以解决的，而我却选择了靠别人，有时候自己研究一下也是很有用的！！！

[yinpan527]

谢谢了

[灰太狼的往事]

为什么非要分组呢

[zn85600301]

貌似是聚合函数 要分组吧