I have a query that I think I am making more complicated than it needs to be and would like to make it simpler.
I have attached the query below, what I have is this statement that tell me to show the record if it contains the number 1,2,3 if not to show an empty record "orderdetails.DetailItemID
= 1 OR orderdetails.DetailItemID = 2 OR orderdetails.DetailItemID = 3".
Is there an easier way to say this i.e ( i know this does not work but something like) "orderdetails.DetailItemID
= 1,2,3" I do not want to use <= 3 because in the future I may need to include more numbers that are not in order i.e 1,2,3,7,10 that the query will need to check for.
Many thanks as always for your help
WHERE orderdetails.DetailsMemberID = 1 AND orderdetails.ProgramActivated = 0 AND orderdetails.DetailItemID = 1 OR orderdetails.DetailItemID = 2 OR orderdetails.DetailItemID = 3
ORDER BY orderdetails.DetailsID DESC