Sams Teach Yourself SQL in 10 Minutes, Second Edition

Combining WHERE Clauses

All the WHERE clauses introduced in Lesson 4, “Filtering Data,” filter data using a single criteria. For a greater degree of filter control, SQL lets you specify multiple WHERE clauses. These clauses may be used in two ways: as AND clauses or as OR clauses.

Operator A special keyword used to join or change clauses within a WHERE clause. Also known as “logical operators.”

Using the AND Operator

To filter by more than one column, you use the AND operator to append conditions to your WHERE clause. The following code demonstrates this:

 SELECT prod_id, prod_price, prod_name FROM Products WHERE vend_id = 'DLL01' AND prod_price ...