How to Make a Report From More Than One Table

In this chapter In this chapter, you create a report that combines information from two tables, the DEPARTMENT table and the EMPLOYEE table.

CA OLQ Release nn.n *** Display Report *** -> Page 1 Line 1 125004 Press the ENTER key for DISPLAY/FORMAT ACTIVITY selections DEPARTMENT/EMPLOYEE REPORT mm/yy/dd DEPT-NAME EMP-ID EMP-LAST-NAME START-YEAR ------------------------- ------ --------------- ---------- PUBLIC RELATIONS 0007 BANK 78 PUBLIC RELATIONS 0120 ANGELO 79 PUBLIC RELATIONS 0127 MCDOUGALL 90 PUBLIC RELATIONS 0149 PENMAN 87 PUBLIC RELATIONS 0158 JACKSON 87 PUBLIC RELATIONS 0476 ZEDI 86 THERMOREGULATION 0329 FINN 89 THERMOREGULATION 0349 WILCO 89 THERMOREGULATION 0355 TIME 81 THERMOREGULATION 0469 KASPAR 80 THERMOREGULATION 0479 CLOTH 89 END OF REPORT - 1 - 1=HELP 3=QUIT 4=MESSAGE 6=MENU 10=LEFT 11=RIGHT top=no.Key Terms

Join

A relational operation through which two or more tables are combined. Tables are joined based on columns that the tables have in common.

Join criteria

A logical expression that compares like columns in two or more tables.

Project

A relational operation through which only particular columns of a table are accessed.

Select

A relational operation through which only particular rows of a table are accessed.

Selection criteria

An expression that specifies which rows of a table are to be selected for processing.

This section contains the following topics:

How to Combine Data From More Than One Table

Creating your report