To select records in the Sales table that have no related records in the Customers table, create a(n) _____ join.
A) inner
B) referential
C) self
D) outer

Question

Quizplus · Accepted Answer

An outer join is used to combine records from two tables, including all of the records from one table and only the matching records from the other table. In this case, we want to select records from the Sales table that have no related records in the Customers table, which means that we need to include all of the records from the Sales table and only the matching records from the Customers table. Therefore, an outer join is the best choice.

To Select Records in the Sales Table That Have No