Joining data from more than one table

 

Sometimes the information you want to see is not in a single table. To form a row of the result table, you might want to retrieve some column values from one table and some column values from another table. You can retrieve and join column values from two or more tables into a single row. Several different types of joins are supported by DB2® UDB for iSeries™: inner join, left outer join, right outer join, left exception join, right exception join, and cross join.

 

Usage notes on join operations

When you join two or more tables, consider the following items:

 

Parent topic:

Retrieving data using the SELECT statement