SELECT MYTABLE.MY_ID FROM MYTABLE WHERE MYTABLE.MY_ID < 100 AND MYTABLE.MY_ID IN ( 2,15,19,20,21,48,49 )
Both parts of the AND expression work OK on their own, but when combined you get 0 rows
Thanks Tim
SELECT MYTABLE.MY_ID FROM MYTABLE WHERE MYTABLE.MY_ID < 100 AND MYTABLE.MY_ID IN ( 2,15,19,20,21,48,49 )
Both parts of the AND expression work OK on their own, but when combined you get 0 rows
Thanks Tim