SQL
- An inner join returns matching row pairs; an outer join also preserves unmatched rows from one side.
- A one-to-many join can multiply rows. Check key uniqueness before interpreting a count or sum.
- Use explicit JOIN ... ON syntax and qualify columns that occur in more than one table.