Posted by strawberry on 04/01/06 14:29

OK, so the correct answer should be:

SELECT pr.propertyid, pr.valuationdate, pr.valuation
FROM properties pr, (

SELECT max( valuationdate ) AS maxdate, propertyid
FROM properties
GROUP BY propertyid
)maxresults
WHERE pr.propertyid = maxresults.propertyid
AND pr.valuationdate = maxresults.maxdate

[Back to original message]