For an example of Boolean numeric expressions, see Boolean Numeric Expressions. The AND Operator If both of the quantities linked by AND are 1 (true), then the result of the AND operation is 1; ...

You can combine or modify WHERE expressions by using the logical operators (also called Boolean operators) AND, OR, and NOT. The basic syntax of a compound WHERE expression is: WHERE ...