Asked by Paula Perez on Sep 29, 2024

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

Left Outer

Refers to a type of SQL join that returns all rows from the left table and the matched rows from the right table, with nulls where there is no match.

One-to-Many Relationship

A type of database relationship where a record in one table can be associated with one or more records in another table.

  • Learn about the implementation of joins to determine specific record relationships via queries.