Question 1. of 15

The INNER JOIN clause...

returns only the rows from the first table, which have non-matching values with the second table in the field on which the 2 tables are joined.

returns all rows that have matching value in the field on which the 2 tables are joined.

returns all rows from 2 tables.