The trouble with this is it returns 1. It seems to pick the max value for the year instead of by day.
--ja On Mon, 20 Oct 2003, Franz, Fa. PostDirekt MA wrote: > Hi, > > maybe I didn't understand the question wrong. > > >I have tried to work in the MAX(aqiNumber) into the query but I get a GROUP > error. > > That is what I try to prevent here: > > SELECT aqiValues.readingDate, MAX(aqiValues.aqiNumber) > FROM aqiRegions, aqiSites, aqiValues > WHERE aqiRegions.aqiRegionID = aqiSites.aqiRegionID AND > aqiValues.site_name = aqiSites.siteNumber > aqiRegions.showOnSite = 1 > GROUP BY aqiValues.readinDate; > > I know this i'nt the whole query, but it might be a hint. > I hope this helps > Klaus > > > -- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
