If you want to find records in the table on the "one" side of a one-to-many relationship that do not have related records in the "many" side, which join do you use?
A) inner
B) self
C) outer
D) cascading

Question

Quizplus · Accepted Answer

You would use an outer join, specifically a left outer join, to find records on the "one" side that do not have related records in the "many" side. The left outer join will return all records on the "one" side and any related records on the "many" side, but will also return null values for any records on the "one" side that do not have related records on the "many" side.

If You Want to Find Records in the Table on the "One