A SELF JOIN joins a table with itself using distinct aliases; a CROSS JOIN combines every row of table A with every row of table B. Key Sub-topics: • Sub-topic 1: SELF JOIN with table aliasing to resolve employee-to-manager and category-to-parent hierarchies • Sub-topic 2: CROSS JOIN mechanics: Cartesian product (N x M rows) and intentional uses for calendar matrix generation
The comprehensive walkthrough, production source code snippets, architectural state diagrams, and downloadable capstones for this topic are reserved exclusively for enrolled students of SQL & Databases.