Question:
I have a form in which the user can select multiple values of “Manufacturer” from a drop-down list.
The query should then select from the database all records in which Manufacturer matches one of those listed. It works fine when a single manufacturer is selected, but what syntax do I use to match multiple Manufacturers?
Answer:
Using the IN predicate in your WHERE clause will match the records:
…WHERE manufacturer IN (selection_list);The exact syntax will depend on your database product — you may be able tospecify variable names to make the statement more portable. Check yourdocumentation for the details.