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

Question

Quizplus · Accepted Answer

A right outer join includes all records from the right table, Sales, and only matching records from the left table, Customers, while returning NULL values for any non-matching left table records. In this case, we want to select records in the Sales table that have no related records in the Customers table, so using a right outer join will ensure that we include all Sales records while only returning NULL values for non-matching Customers records.

To Select Records in the Sales Table That Have No