In previous chapters, you learned about the WHERE clause and how you could use it to restrict the results you see. You can do this using a variety of symbols, called operators , such as “equal to” and “less than.” You can also specify multiple criteria using the AND/OR keywords.
Working with lists of values presents an interesting challenge in that a large list can result in a large number of AND and OR keywords in a query. This chapter introduces some syntax that’s helpful when working with large lists. You’ll also learn about some syntax for ...