skip to main content
SQL Statements for Flat-File Drivers : Select Statement : SQL Expressions : Logical Operators
  
Logical Operators
Two or more conditions may be combined to form more complex criteria. When two or more conditions are present, they must be related by AND or OR. For example:
salary = 40000 AND exempt = 1
The logical NOT operator is used to reverse the meaning. For example:
NOT (salary = 40000 AND exempt = 1)