What does the INNER JOIN command select from related tables?
A)all records in the parent table even if they do not have matching records in the child table
B)records that have matching values in both tables
C)all records in the child table even if they do not have matching records in the parent table
D)all records in both tables even if they do not have matching records

Question

Quizplus · Accepted Answer

INNER JOIN selects records that have matching values in both tables. This means it will only return the rows where there is at least one match in both tables being joined.

What Does the INNER JOIN Command Select from Related Tables