A SQL clause that combines rows from two or more tables based on a related column. Types include INNER JOIN, LEFT JOIN, RIGHT JOIN, and CROSS JOIN. Understanding join order and ensuring indexed join columns is essential for efficient queries.
