To present data from two tables, draw two example tables that have at least one column that contains the same data (in the example, ID and MANAGER). Add one or more unnamed columns to one of the tables. Enter the same example element in each table in the columns that contain the same data. Then, enter another example element in an unnamed column of the first table, and enter that same example element in a named column of the second table. (P. can appear only in the table with the unnamed column.)
When you run this query:
Q.STAFF | ID | NAME | |
--------+----+------+------|
P. | _I | | _D |
Q.ORG | DEPTNUMB | DEPTNAME | MANAGER |
------+----------+----------+---------|
| _D | | _I |
|
QMF produces this report:
ID NAME DEPTNUMB
------ --------- --------
10 SANDERS 20
30 MARENGHI 38
50 HANES 15
100 PLOTZ 42
140 FRAYE 51
160 MOLINARE 10
270 LEA 66
290 QUILL 84