JOIN with temp tables
JOIN with hierarchical data
JOIN with self-referencing table
JOIN using UNION ALL operator
JOIN using EXCEPT operator