Syntax Check: Group BY with Joins

2004-01-27 Thread Eric Ellsworth
Hi, I'm having trouble with this query: SELECT Max(DATE_ADD('1970-1-1',INTERVAL Lastupdate/3600/24 DAY)) as BaskDate, ofm_baskets.Code, Sum(ofm_baskets.Quantity) AS TotalQty FROM (ofm_basklist INNER JOIN ofm_basklupd ON ofm_basklist.Session_id = ofm_basklupd.Session_id) INNER JOIN

RE: Syntax Check: Group BY with Joins

2004-01-27 Thread Lopez David E-r9374c
Eric Try putting the HAVING clause after group by. I believe having is the last clause (may be LIMIT). David -Original Message- From: Eric Ellsworth [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 27, 2004 8:01 AM To: [EMAIL PROTECTED] Subject: Syntax Check: Group BY with Joins

Re: Syntax Check: Group BY with Joins

2004-01-27 Thread Eric Ellsworth
] To: 'Eric Ellsworth' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, January 27, 2004 10:09 AM Subject: RE: Syntax Check: Group BY with Joins Eric Try putting the HAVING clause after group by. I believe having is the last clause (may be LIMIT). David -Original Message- From: Eric