left outer join

Definition from Wiktionary, the free dictionary
Jump to navigation Jump to search

English[edit]

A Venn Diagram showing the left circle and overlapping portion filled.
A Venn Diagram representing the left outer join between tables A and B.

Noun[edit]

left outer join (plural left outer joins)

  1. (databases) A join yielding a set of records for two tables, where all rows of the "left" table are enlisted with all rows of the "right" table, even if the join condition does not find any matching row on the "right".

Synonyms[edit]

Antonyms[edit]

Hypernyms[edit]

References[edit]