Re: Syntax Check: Group BY with Joins

AIL PROTECTED]> 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 >

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 Ellsworth [mailto:[EMAIL PROTECTED] > Sent: Tuesday, January 27, 2004 8:01 AM > To: [EMAIL PROTECTED] > S

Syntax Check: Group BY with Joins

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 ofm_basket