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) left outer
D) cascade updates

Question

Quizplus · Accepted Answer

A left outer join will return all records from the table on the "one" side of the relationship, including those that do not have related records in the "many" side. The unmatched records from the "one" table will have NULL values in the corresponding columns from the "many" table. This allows us to filter for only the unmatched records. Inner join will only return matched records, self join can be used for other purposes, and cascade updates is a referential integrity action, not a join type.

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