full outer join

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

Noun

full outer join (plural full 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 "left" or on the "right" table.

Synonyms

Hypernyms

References
This article is issued from Wiktionary. The text is licensed under Creative Commons - Attribution - Sharealike. Additional terms may apply for the media files.