Word.ws English Dictionary

full outer join

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.

full outer join: a join yielding a set of records for two tables, where all rows of the "left" table are enlisted...
Image: GermanX, CC BY-SA 4.0, via Wikimedia Commons

Noun

full outer join (plural full outer joins)

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

Synonyms of full outer join

Forms of full outer join

pluralfull outer joins

Questions about full outer join

What does full outer join mean?
Full outer join means 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.
What part of speech is full outer join?
Full outer join is a noun.
What is the plural of full outer join?
The plural of full outer join is full outer joins.

Words near full outer join in the dictionary

  1. full of shit
  2. full of the devil
  3. full of the joys of spring
  4. full on
  5. full out
  6. full outer join
  7. full outer joins
  8. full pelt
  9. full pint
  10. full pints
  11. full point

Source and license

Adapted from Wiktionary: full outer join (page history and authors). Text available under the Creative Commons Attribution-ShareAlike 4.0 license. Word.ws reformatted the entry and added links. Wiktionary data of 2026-09-02.

Last updated:

Cite this entry: “full outer join.” Word.ws, https://word.ws/full_outer_join. Based on Wiktionary, CC BY-SA 4.0.