Mike,
>How would this query be constructed with the HAVING clause,
>not real fimilar with this type of clause.
SELECT
a.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
GROUP BY a.account_id
HAVING SUM(c.agent_product_time) >= 500
ORDER BY mins;
PB
-----
Mike Blezien wrote:
Peter,
----- Original Message ----- From: "Peter Brawley"
<[EMAIL PROTECTED]>
To: "Mike Blezien" <[EMAIL PROTECTED]>
Cc: "MySQL List" <mysql@lists.mysql.com>
Sent: Tuesday, May 16, 2006 1:07 PM
Subject: Re: Baffled by error
Mike Blezien wrote:
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
WHERE doesn't understand aggregation. Move the condition
SUM(c.agent_product_time) >= 500 to a HAVING clause.
pb
How would this query be constructed with the HAVING clause, not real
fimilar with this type of clause.
thx's
Mike
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.392 / Virus Database: 268.5.6/340 - Release Date: 5/15/2006
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]