ASA Getting Started
  Selecting Data from Database Tables
    Selecting rows from a table

Using compound search conditions

Search conditions can be combined using the AND and OR logical operators to make compound search conditions. Each individual piece of the search condition is sometimes called a predicate.

List all employees born before March 13, 1964, except the employee named Whitney

• In Interactive SQL, type the following in the SQL Statements pane:

  SELECT emp_lname, birth_date
  FROM employee
  WHERE birth_date < '1964-3-13'
  AND emp_lname <> 'whitney'

  emp_lname	birth_date
  Cobb	12/4/1960
  Jordan	12/13/1951
  Breault	5/13/1947
  Espinoza	12/14/1939
  Dill	7/19/1963
  Francis	9/12/1954