Joins combine rows from two tables based on a condition.
1Types
INNER JOIN: matching rows only
LEFT/RIGHT OUTER JOIN: all rows from one side plus matches (NULLs otherwise)
FULL OUTER JOIN: all rows from both
CROSS JOIN: Cartesian product
Self join: a table joined to itself