Two conditions connected by AND cause the query to select only rows that satisfy both conditions. The query below selects rows where the YEARS column is equal to 10, and the SALARY column is greater than 20000. The query selects only the two rows that satisfy both of these conditions.
When you run this query:
Q.STAFF | ID | NAME | DEPT | JOB | YEARS | SALARY | COMM |
--------+----+------+------+-----+-------+--------+------|
| P. | P. | | | P. _Y | P. _S | |
| CONDITIONS |
|-----------------------------|
| _Y = 10 AND _S > 20000 |
|
QMF produces this report:
ID NAME YEARS SALARY ----- --------- ----- --------- 50 HANES 10 20659.80 210 LU 10 20010.00