|
|
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
Navigation:
[Reply to this message]
|