- Inner join: returns records from two tables that meet the join condition.
- Outer join includes left outer join, right outer join, and full outer join, each returning the connected results including unmatched records.
- Self join: Performing a join operation within the same table to compare relationships between different records.
- Cross join returns the Cartesian product of two tables, which is all possible combinations of records from both tables.
- Natural join: Automatically join operations based on columns that are common in both tables.
✖
