Joins

Joins · Basic

INNER JOIN

Returns only rows that match in both joined tables.

Joins · Basic

LEFT JOIN

Keeps all rows from the left table and adds matching right-table data.

Joins · Intermediate

CROSS JOIN

producing a Cartesian product.

Joins · Advanced

SELF JOIN

joining a table to itself.

Joins · Advanced

FULL OUTER JOIN

Keeps every row from both sides of a join.