How to Make a Report From More Than One Table › Creating your report › Step 5— Display your report

Step 5— Display your report

Your report displays information from both the EMPLOYEE and DEPARTMENT tables.

     CA OLQ Release nn.n                          *** Display Report ***
 ->                                                       Page     1 Line     1
125004 press the ENTER key for DISPLAY/FORMAT ACTIVITY selections

                           EMPLOYEE/DEPARTMENT REPORT
                                    mm/dd/yy

     EMP-ID     EMP-LAST-NAME     START-YEAR            DEPT-NAME
     ------    ---------------    ----------    -------------------------
     0007      BANK               78            PUBLIC RELATIONS
     0120      ANGELO             79            PUBLIC RELATIONS
     0149      PENMAN             77            PUBLIC RELATIONS
     0158      JACKSON            77            PUBLIC RELATIONS
     0329      FINN               79            THERMOREGULATION
     0349      WILCO              79            THERMOREGULATION
     0476      ZEDI               76            PUBLIC RELATIONS
     0479      CLOTH              79            THERMOREGULATION
     END OF REPORT




                                      - 1 -
 1=HELP       3=QUIT       4=MESSAGE       6=MENU       10=LEFT       11=RIGHT