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