How to Make a Report From More Than One Table › Creating your report › Step 3— Select, project, and join

Step 3— Select, project, and join

In this step, you perform all three relational operations: select, project, and join:

• Select by restricting the rows of the report to those employees hired before 1990.
• Project by displaying only the DEPT-NAME, EMP-ID, EMP-LAST-NAME, and START-YEAR columns.
• Join by linking the DEPARTMENT and EMPLOYEE tables based on common values of the DEPT-ID field.

Select which columns you want to list in your report, specify that you want to include only those employees hired before 1990, and join the two tables based on common values in the DEPT-ID fields.

      CA OLQ Release nn.n                          *** Column Select ***
  ->                                                       Page     1 of     1
 124000 Select columns, specify selection criteria and press the ENTER key

    Columns Currently Selected:    4     Selection Criteria     Distinct N Y/N
  _ DEPARTMENT
  X 03 DEPT-NAME
  _ 03 DEPT-ID
  _ 03 DEPT-HEAD-ID
  _ EMPLOYEE
  X 03 EMP-ID
  X 03 EMP-LAST-NAME
  _ 03 EMP-FIRST-NAME
  X 03 START-YEAR                        lt 90
  _ 03 DEPT-HEAD-ID
  _ 03 DEPT-ID                           eq department.dept-id
  _ 03 SALARY-AMOUNT
  _ 03 PROJECT
  _ 03 OFFICE-CODE
 Additional Selection Criteria:


                                   Proceed to Selection Criteria Screen? N Y/N

 1=HELP          3=QUIT          4=MESSAGE          6=MENU          PA2=REFRESH