SQL Joins

The join clause allows us to combine SQL tables. Tables can be combined in different ways. Think on inner join as an intersection of two tables and an outer join as a union of two tables. This table explains different types of joins.

We will be using the following two tables in the examples:


If you had to work with IBM products, you probably have had to work with DB2. This page will get you up and running with DB2 in 10 minutes.