Is because in your select you have c.accound_id and in your group by clause you have a.accound_id
Try this: SELECT c.account_id,a.name,a.company,SUM(c.agent_product_time) AS mins FROM account a LEFT JOIN calls c ON c.account_id = a.id WHERE c.calldate >= DATE_SUB(NOW(),INTERVAL 14 DAY) AND c.agent_id = 9 AND SUM(c.agent_product_time) >= '500' GROUP BY c.account_id ORDER BY mins Regards! -----Mensaje original----- De: Mike Blezien [mailto:[EMAIL PROTECTED] Enviado el: Martes, 16 de Mayo de 2006 12:30 p.m. Para: MySQL List Asunto: Baffled by error Hello, MySQL 4.1.12 trying to figure out why I keep getting this error with the following query: SELECT c.account_id,a.name,a.company,SUM(c.agent_product_time) AS mins FROM account a LEFT JOIN calls c ON c.account_id = a.id WHERE c.calldate >= DATE_SUB(NOW(),INTERVAL 14 DAY) AND c.agent_id = 9 AND SUM(c.agent_product_time) >= '500' GROUP BY a.account_id ORDER BY mins ERROR: #1111 - Invalid use of group function Any help appreciated... Mike(mickalo)Blezien =============================== Thunder Rain Internet Publishing Providing Internet Solution that Work http://www.thunder-rain.com =============================== -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
