Ok I have a table called SaleProperty which includes house prices

Now I want to output the property with the highest value and the lowest value so i came up with:

FROM SaleProperty
WHERE price = (SELECT MIN(price) FROM SaleProperty)
price = (SELECT MAX(price) FROM SaleProperty);

Is there a better way of doing this? i.e. with one sub query instead of two?


Note: this is in MS Access XP 2002