Gordon,
thank you, works prefectly now.
Mike
- Original Message -
From: "Gordon" <[EMAIL PROTECTED]>
To: "'Mike Blezien'" <[EMAIL PROTECTED]>; "'MySQL List'"
Sent: Tuesday, May 16, 2006 3:17 PM
Subject: RE: Baffled by
SUM(c.agent_product_time) >= '500'
ORDER BY mins
You have to do the SUM with the GROUP BY before you can test the
criteria
-Original Message-
From: Mike Blezien [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 16, 2006 10:30 AM
To: MySQL List
Subject: Baffled by error
Hello,
MySQL 4
Peter,
- Original Message -
From: "Peter Brawley" <[EMAIL PROTECTED]>
To: "Mike Blezien" <[EMAIL PROTECTED]>
Cc: "MySQL List"
Sent: Tuesday, May 16, 2006 1:25 PM
Subject: Re: Baffled by error
Mike,
>How would this query be constructed w
;MySQL List"
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
Peter,
- Original Message -
From: "Peter Brawley" <[EMAIL PROTECTED]>
To: "Mike Blezien" <[EMAIL PROTECTED]>
Cc: "MySQL List"
Sent: Tuesday, May 16, 2006 1:07 PM
Subject: Re: Baffled by error
Mike Blezien wrote:
Hello,
MySQL 4.1.12
tr
- Original Message -
From: "Rhino" <[EMAIL PROTECTED]>
To: "Mike Blezien" <[EMAIL PROTECTED]>; "MySQL List"
Sent: Tuesday, May 16, 2006 1:56 PM
Subject: Re: Baffled by error
- Original Message -
From: "Mike Blezien"
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
corrected it and still the same error.
Mike
- Original Message -
From: "Chris Sansom" <[EMAIL PROTECTED]>
To: "Mike Blezien" <[EMAIL PROTECTED]>; "MySQL List"
Sent: Tuesday, May 16, 2006 12:56 PM
Subject: Re: Baffled by error
At 12:29 -05
MAIL PROTECTED]>; "'MySQL List'"
Sent: Tuesday, May 16, 2006 12:58 PM
Subject: RE: Baffled by error
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)
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
At 12:29 -0500 16/5/06, Mike Blezien wrote:
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
- Original Message -
From: "Mike Blezien" <[EMAIL PROTECTED]>
To: "MySQL List"
Sent: Tuesday, May 16, 2006 1:29 PM
Subject: Baffled by error
Hello,
MySQL 4.1.12
trying to figure out why I keep getting this error with the following
query:
SELECT c.a
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 =
13 matches
Mail list logo