Two conditions connected by OR allow the query to select every row that satisfies one or the other of the conditions. The following query selects rows where either the YEARS column is equal to 10 or the SALARY column is greater than 20000.
When you run this query:
Q.STAFF | ID | NAME | DEPT | JOB | YEARS | SALARY | COMM |
--------+----+------+------+-----+-------+--------+------|
| P. | P. | | | P. _Y | P. _S | |
| CONDITIONS |
|-----------------------------|
| _Y = 10 OR _S > 20000 |
|
QMF produces this report:
ID NAME YEARS SALARY ----- --------- ----- --------- 50 HANES 10 20659.80 140 FRAYE 6 21150.00 160 MOLINARE 7 22959.20 210 LU 10 20010.00 260 JONES 12 21234.00 290 QUILL 10 19818.00 310 GRAHAM 13 21000.00