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_baskets ON ofm_basklist.Basket_id =
ofm_baskets.Id
GROUP BY ofm_baskets.Code
HAVING (((ofm_basklist.Order_id)=0))
ORDER BY Max(DATE_ADD('1970-1-1',INTERVAL Lastupdate/3600/24 DAY));
I get the following error:
ERROR 1111: Invalid use of group function
Can someone give me an idea of what's wrong with this query? I'm using MySQLd version
4.0.16.
Thanks,
Eric