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

Figure 2-28 shows a data search example involving multiple conditions. Here, product codes and ordered quantities are searched from the stock table for products whose name is either BLOUSE or POLO SHIRT with 50 or more units in a stock.

Figure 2-28 Data search example involving multiple conditions