>>>>You should get the wroong date returned.
>
>I played with that, and you're wrong (at least in my dimension!)
Larry is not saying that you will get the wrong temperature for each city; he is saying that your query will tell you the wrong DATE for that temperature. Just looking at your query, I would think the date would be incorrect, unless the MAX temperature was on the last record for each city.
Are the dates correct in your results?
Steve Gibson