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

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

Quizplus · Accepted Answer

INNER JOIN selects records with matching values in both tables. It does not include any records that do not have a match in the other table.

What Does the INNER JOIN Command Select from Related Tables