Inner Join
In plain terms
A join returning only rows with matches in both tables.
Going deeper
An inner join keeps only records where the join condition matches on both sides, dropping unmatched rows. It's the most common join.
Under the hood
Excludes non-matching rows entirely; the default 'JOIN' in SQL.
Examples
Matching orders to existing customers, intersecting datasets, SQL JOIN.
Think of it like...
Like listing only people who appear on both the invite list and the RSVP list.