Filter
Top Products
Example 3 illustrates coding RIGHT for the outer join type. If LEFT is coded for the outer join type in the same
example statements, the results are as follows:
5.3 Manipulating Data Using Aliases in Tables
If column names are qualified by long table names, coding columns may become time-consuming. Instead, data can
be manipulated by specifying correlation names for tables in table expressions. The following is an example of
specifying correlation names:
Example:
In this example, correlation names are used as column name qualifiers in the query specification in
Figure: Example in which multiple tables are joined and data manipulated. The result of the query
specification is the same as in Figure: Example in which multiple tables are joined and data
63