Which of the following is NOT true regarding inner joins?
A)Only one field can serve as a join field.
B)An inner join is a join that selects only those records from both database tables that have matching values.
C)Records with values in the joined field that do not appear in both of the database tables will be excluded from the query dataset.
D)To create an inner join,select the "Only include rows where the joined fields from both tables are equal" option in the Join Properties dialog box.

Question

Quizplus · Accepted Answer

This statement is not true. Multiple fields can serve as join fields, as long as they have matching values in both tables.

Which of the Following Is NOT True Regarding Inner Joins