Multiple choice technology databases

The INNER JOIN clause…

  1. returns all the matching rows from 2 tables.

  2. 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.

  3. returns all rows from 2 tables.

  4. returns all rows that have matching value in the field on which the 2 tables are joined.
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

An INNER JOIN selects and returns only the rows from both tables that satisfy the join condition (matching values in the specified fields). Rows that do not have matching values in both tables are excluded.

Keep practicing — related questions