Using QMF

Selecting rows If either condition is true

If you want to select rows that meet either condition, use the OR keyword to connect them.

The following query displays the same columns in the Q.STAFF table, but selects employees who have either 10 years of service or earn more than $20,000.00.

SELECT ID, NAME, YEARS, SALARY
  FROM Q.STAFF
  WHERE YEARS = 10
    OR SALARY > 20000