The logical operators AND, OR, and NOT manipulate rows containing data that satisfies multiple conditions.

The following figure shows, as an example of a data search that satisfies multiple conditions, the procedure for searching the stock table for the product codes and quantities ordered for products whose name is either BLOUSE or POLO SHIRT, and that have 50 or more units in stock.

Figure 2-28 Data search example involving multiple conditions