A SQL JOIN combines records from two tables.

A JOIN locates related column values in the two tables using key-values.

A query can contain one or multiple combinations of JOIN operations.

Types of JOINS:

INNER JOIN: Returns all rows when there is at least one match in BOTH tables.

LEFT JOIN: Return all rows from the LEFT table, and the matched rows from the right table.

RIGHT JOIN: Return all rows from the RIGHT table, and the matched rows from the left table.

FULL JOIN: Combines the results of both Left and Right outer joins.

SQL Tutorial