List:General Discussion« Previous MessageNext Message »
From:Mike Blezien Date:May 17 2006 1:07pm
Subject:Baffled by query error syntax
View as plain text  
Hello,

this is a continued problem we are having from a earlier posting to the list 
regarding a query. We need to calculate the SUM of the column 
'agent_product_time' which is a TIME datatype column and according to the 
manual:
http://dev.mysql.com/doc/refman/4.1/en/date-and-time-type-overview.html
this is the way to SUM the total time, which keeps producing a syntax error and 
figure out why

MySQL version 4.1.12
---------------------------------------------------------------------------------------------------
SELECT c.account_id,a.name,a.company,
SEC_TO_TIME(SUM(TIME_TO_SEC(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 = 2 GROUP BY c.account_id HAVING mins >= '500' ORDER BY mins

ERROR:
#1064 - You have an error in your SQL syntax; check the manual that corresponds 
to
your MySQL server version for the right syntax to use near
'( SUM( TIME_TO_SEC( c . agent_product_time ) ) ) AS mins  FROM account a LEFT 
JO' at line 1
--------------------------------------------------------------------------

What would be producing the syntax error here.??

Again, any help would be much appreciated.

Mike(mickalo)Blezien
===============================
Thunder Rain Internet Publishing
Providing Internet Solution that Work
http://www.thunder-rain.com
=============================== 

Thread
Baffled by query error syntaxMike Blezien17 May
  • Re: Baffled by query error syntaxsheeri kritzer17 May
    • Re: Baffled by query error syntaxMichael Stassen18 May
  • Re: Baffled by query error syntaxMike Blezien17 May
  • Re: Baffled by query error syntaxMichael Stassen18 May