JOIN using aliases
JOIN ON single column
JOIN ON multiple columns
OUTER JOIN
SEMI-JOIN