✏️ Explanatory Question
Inner vs. Outer: The core difference is how they handle non-matching records. An inner join discards them, while an outer join keeps them from the primary table and shows empty values for fields from the secondary table