left outer join

English

A Venn Diagram representing the left outer join between tables A and B.

Noun

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

• left join

Antonyms

• right outer join

Hypernyms

• outer join

References

• left outer join on Wikipedia.Wikipedia