Which join type returns only the rows that have matching values in BOTH tables?
- A. Inner join✓ Correct
- B. Left join
- C. Full outer join
- D. Union
Explanation
An inner join returns only rows with matches in both tables. A left join (B) keeps all left-table rows plus matches, a full outer join (C) keeps all rows from both, and a union (D) stacks rows from tables (not a join at all).