full outer join

noun

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.

Similar
full join
Ask AI about this wordChatGPTClaudePerplexityGoogle AIGrok

Meanings

nounfull outer join (plural full outer joins)

plural full outer joins

  1. computingA 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: full join

Synonyms & antonyms

nounA 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.

Similar
full join
Cite this entry
APA

full outer join. (n.d.). In WatkinsX Dictionary. Retrieved November 3, 2026, from https://dictionary.watkinsx.com/word/full%20outer%20join

MLA

“full outer join.” WatkinsX Dictionary, https://dictionary.watkinsx.com/word/full%20outer%20join. Accessed November 3, 2026.

Chicago

WatkinsX Dictionary, s.v. “full outer join,” accessed November 3, 2026, https://dictionary.watkinsx.com/word/full%20outer%20join.

Source: full outer join on Wiktionary, CC BY-SA 4.0.