Can you search a database using more than one field?

In some instances, you might want to apply a number of search conditions to the same data column.

• Search for several different names in an employee table or for employees who are in different salary ranges.

-This type of search requires an OR condition.

• Search for a book title that both starts with the Word "The" and contains the Word "Cook."

This type of search requires an AND condition.

To search for alternative values in the same data column, you specify an OR condition.

To search for values that meet several conditions, you specify an AND condition.