A query using multiple tables can present data from one table that is dependent on data in another table. For example, using the example element _D in the DEPT column of Q.STAFF and the DEPTNUMB column of Q.ORG, you can present the ID, name, and department of only those employees who are located in Dallas.
When you run this query:
Q.STAFF | ID | NAME | DEPT |
--------+----+------+-------|
P. | | | _D |
Q.ORG | DEPTNUMB | LOCATION |
------+----------+----------|
| _D | DALLAS |
|
QMF produces this report:
ID NAME DEPT ------ --------- ---- 140 FRAYE 51 150 WILLIAMS 51 220 SMITH 51 230 LUNDQUIST 51 250 WHEELER 51