Sql query that doesnt work tryign to use between two values

[DanielStead]

Here is the sql statement

 

SELECT ParcelID, x, y

FROM Polygons

WHERE Parish = '{Stadhampton}'

AND ParcelID = 91

AND x BETWEEN 460000 AND 460500

AND y BETWEEN 199000 AND 199500;

 

Not really too sure bout the between statements as the query worked fine why i didnt use between anyone any ideas as i have never used between before

 

[Honoré]

[!--quoteo(post=323926:date=Dec 2 2005, 05:52 PM:name=DanielStead)--][div class=\'quotetop\']QUOTE(DanielStead @ Dec 2 2005, 05:52 PM) 323926[/snapback][/div][div class=\'quotemain\'][!--quotec--]

SELECT ParcelID, x, y

FROM Polygons

WHERE Parish = '{Stadhampton}'

AND ParcelID = 91

AND x BETWEEN 460000 AND 460500

AND y BETWEEN 199000 AND 199500;

try

SELECT ParcelID, x, y
FROM Polygons
WHERE Parish = '{Stadhampton}'
AND ParcelID = 91
AND (x BETWEEN 460000 AND 460500)
AND (y BETWEEN 199000 AND 199500);