- Inner Join: Connect two tables using a common field and return only the matching records from both tables.
- Outer Join:
- Left Join: Returns all records from the left table, as well as matching records from the right table.
- Right Join: Returns all records from the right table, as well as the records from the left table that match the right table.
- Full join: Returns all records from both the left and right tables, returning NULL if there is no match.
- Self Join: Connecting a table to itself in a query to compare data from different rows within the same table.
- Cross Join: Returns the Cartesian product of two tables, where every row of each table is combined with every row of the other table.
- Using a subquery: embedding the result of one query within another query to achieve a table join query.
✖
