Data & Databases
Left Join
A join retaining every row from its left input while attaching matching right-side rows. Where no match exists, right-side fields are NULL. A later filter on those fields can remove the unmatched rows again.
Also called: Left Outer Join
Reviewed
Sources
Member lesson
The definition and sources are public. The complete practical lesson is for members.