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.
Learning Objectives
- Learn about the implementation of joins to determine specific record relationships via queries.