I am using IN with a query of mine to select products based on variant filters and I have noticed that it selects very much like the OR operator. is there a way to make this work the same as AND?
Query is very much like the attached code
WHERE filterOptionID IN(1,20,25,13,19)
ORDER BY TitleDesc, SortOrd, ProdCode