What type of join should you use to create a query from a parent table named Customers and a child table named Orders where the linking field contained values in both tables?
A)OUTER
B)LEFT
C)RIGHT
D)INNER

Question

Quizplus · Accepted Answer

An INNER JOIN should be used to create a query from a parent table and a child table where the linking field contains values in both tables. This type of join returns rows when there is at least one match in both tables.

What Type of Join Should You Use to Create a Query