Use a query to _____ tables; that is, to find records in two tables that have identical values in matching fields.
A)combine
B)concatenate
C)merge
D)join

Question

Quizplus · Accepted Answer

The correct term for finding records in two tables with identical values in matching fields is to join the tables. Therefore, the best choice is D, join. A and B are incorrect because combining or concatenating tables does not necessarily involve finding records with identical values. C is also incorrect because merging tables typically involves combining the data into a new table rather than finding records with identical values.

Use a Query to _____ Tables; That Is, to Find