SQL JOIN in DB2 for i SQL

SQL JOIN in DB2 for i SQL

A JOIN clause can be used to combine rows from two or more tables based on some related columns between them. We can select rows from multiple table tables, join them in a single result and displays them in a single row format.

Types of SQL JOINS

There are different types of JOINS available in SQL DB2 for i.

1. INNER JOIN
2. LEFT OUTER JOIN
3. RIGHT OUTER JOIN
4. EXCEPTION JOIN
5. CROSS JOIN
6. FULL OUTER JOIN