using two BETWEEN statments 1

[3dColor]

I can use one BETWEEN statement in my query below just fine, but when i add the second one it doesn't return both ranges:

SELECT	csName, csId, stateFk, coords
FROM 	Cs
WHERE	stateFk = 1
	AND csId BETWEEN 53 AND 999
	AND csId BETWEEN 1001 AND 1006

 

[TonyGroves]

Presumably you mean:
[tt]
AND
(
csId BETWEEN 53 AND 999
OR csId BETWEEN 1001 AND 1006
)
[/tt]
csID can't be within the first range and within the second range at the same time! If it's in either range it will satisfy the condition.

 

[3dColor]

Oh yea, i wasn't think of it that way.

Thanks!