Joins in SELECT statements

A join is a relational operation in a SELECT statement that retrieves data from two or more tables, based on matching column values. The data in the tables is linked into a single result.

The IMS™ Explorer supports the inner join operator. In an inner join, each row of the first table is combined with each row of the second table, keeping only the rows where the join condition is true. The results table might be missing rows from either or both of the joined tables.




© Copyright IBM Corporation 2010, 2017.