Which rows survive the join?

Question

Accepted Answer

INNER JOIN returns only rows where the join condition matches in both tables. Carol has NULL dept_id which matches no department id, so she is excluded. HR (id 30) has no matching employee, so it is also excluded. Only Alice and Bob have matching dept_ids.