|
The IN keyword is used to select one from a group
of values. The formula to follow is:
IN(Expression1, Expression2, Expression_n)
|
Each Expression factor can be one of the values
of a column. This is equivalent to Expression1 OR
Expression2 OR Expression3, etc.
Here is an example that shows the list of movies
directed by either Oliver Stone or Ron Howard:
SELECT Videos.Title, Videos.Director, Videos.CopyrightYear, Videos.Rating
FROM Videos
WHERE (Videos.Director) IN ("Oliver Stone","Ron Howard");