Outerjoins
Outerjoins in practice
- A query navigates between Entities via Relationships
- Outerjoins avoid dropping entities with no related entities across a relationship>
E.g., List book titles and authors
- book join author: drops books with unknown authors.
- book left join author: keeps books with unknown authors.
|