To see only certain rows of a table, add conditions to your query. For example, present all the Q.STAFF table columns, but only the rows that contain SALES in the JOB column.
When you run this query:
Q.STAFF | ID | NAME | DEPT | JOB | YEARS | SALARY | COMM | --------+----+------+------+-------+-------+--------+------| P. | | | | SALES | | | | |
QMF produces this report:
ID NAME DEPT JOB YEARS SALARY COMM
------ --------- ------ ----- ------ ---------- ----------
20 PERNAL 20 SALES 8 18171.25 612.45
40 O'BRIEN 38 SALES 6 18006.00 846.55
60 QUIGLEY 38 SALES - 16808.30 650.25
70 ROTHMAN 15 SALES 7 16502.83 1152.00
90 KOONITZ 42 SALES 6 18001.75 1386.70
150 WILLIAMS 51 SALES 6 19456.50 637.65
220 SMITH 51 SALES 7 17654.50 992.80
280 WILSON 66 SALES 9 18674.50 811.50
300 DAVIS 84 SALES 5 15454.50 806.10
310 GRAHAM 66 SALES 13 21000.00 200.30
320 GONZALES 66 SALES 4 16858.20 844.00
340 EDWARDS 84 SALES 7 17844.00 1285.00