Joins in DB2 SQL

An SQL join is a query that combines data from two tables using one or more common columns to create a relationship between both tables.

The four main join types produce the following results (T1 is the first table and T2 the second):

INNER JOIN: Rows from T1 and T2 that satisfy the join condition […]