Which join type will only include rows where the joined fields from both tables are equal?

An inner join returns rows only when the joined fields have matching, equal values in both tables. A left or right outer join also keeps unmatched rows from one side, so those are not the requested join type. The correct choice is “inner join.”

AI-written and checked against the verified answer.