To see all the columns in a table, put P. under the table name in the example table. All the columns shown in the example table appear.
When you run this query:
Q.ORG | DEPTNUMB | DEPTNAME | MANAGER | DIVISION | LOCATION | ------+----------+----------+---------+----------+----------| P. | | | | | | |
QMF produces this report:
DEPTNUMB DEPTNAME MANAGER DIVISION LOCATION
-------- -------------- ------- ---------- -------------
84 MOUNTAIN 290 WESTERN DENVER
66 PACIFIC 270 WESTERN SAN FRANCISCO
10 HEAD OFFICE 160 CORPORATE NEW YORK
15 NEW ENGLAND 50 EASTERN BOSTON
20 MID ATLANTIC 10 EASTERN WASHINGTON
38 SOUTH ATLANTIC 30 EASTERN ATLANTA
42 GREAT LAKES 100 MIDWEST CHICAGO
51 PLAINS 140 MIDWEST DALLAS