O'Reilly logo

DB2® Universal Database for OS/390® Version 7.1 Certification Guide by Susan Lawson, Richard Yevich

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Joins

The heart of SQL in a relational system is the ability to perform relational joins. Joins are specified by using more than one table name in the FROM clause of a subselect. A joined table specifies an intermediate result table that is the result of either an inner join or an outer join.

Note

The maximum number of tables that can be joined by DB2 is 15 (or 255 if star join is selected), but there can be up to 225 table references in a SQL statement.

Inner Joins

The join operation used most often, which is the one we have been using in the book exercises, is known as an INNER JOIN. An inner join combines each row of the left table with every row of the right table keeping only the rows where the join condition is true. The result table may ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required