"full outer join" meaning in English

See full outer join in All languages combined, or Wiktionary

Noun

Forms: full outer joins [plural]
Head templates: {{en-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. Categories (topical): Databases Synonyms: full join Hypernyms: outer join
    Sense id: en-full_outer_join-en-noun-o5IfBPSv Categories (other): English entries with incorrect language header Topics: computing, databases, engineering, mathematics, natural-sciences, physical-sciences, sciences

Inflected forms

Alternative forms

Download JSON data for full outer join meaning in English (1.4kB)

{
  "forms": [
    {
      "form": "full outer joins",
      "tags": [
        "plural"
      ]
    }
  ],
  "head_templates": [
    {
      "args": {},
      "expansion": "full outer join (plural full outer joins)",
      "name": "en-noun"
    }
  ],
  "lang": "English",
  "lang_code": "en",
  "pos": "noun",
  "senses": [
    {
      "categories": [
        {
          "kind": "other",
          "name": "English entries with incorrect language header",
          "parents": [
            "Entries with incorrect language header",
            "Entry maintenance"
          ],
          "source": "w"
        },
        {
          "kind": "topical",
          "langcode": "en",
          "name": "Databases",
          "orig": "en:Databases",
          "parents": [
            "Computing",
            "Technology",
            "All topics",
            "Fundamental"
          ],
          "source": "w"
        }
      ],
      "glosses": [
        "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."
      ],
      "hypernyms": [
        {
          "word": "outer join"
        }
      ],
      "id": "en-full_outer_join-en-noun-o5IfBPSv",
      "links": [
        [
          "database",
          "database"
        ],
        [
          "join",
          "join"
        ],
        [
          "record",
          "record"
        ]
      ],
      "raw_glosses": [
        "(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": [
        {
          "word": "full join"
        }
      ],
      "topics": [
        "computing",
        "databases",
        "engineering",
        "mathematics",
        "natural-sciences",
        "physical-sciences",
        "sciences"
      ]
    }
  ],
  "word": "full outer join"
}
{
  "forms": [
    {
      "form": "full outer joins",
      "tags": [
        "plural"
      ]
    }
  ],
  "head_templates": [
    {
      "args": {},
      "expansion": "full outer join (plural full outer joins)",
      "name": "en-noun"
    }
  ],
  "hypernyms": [
    {
      "word": "outer join"
    }
  ],
  "lang": "English",
  "lang_code": "en",
  "pos": "noun",
  "senses": [
    {
      "categories": [
        "English countable nouns",
        "English entries with incorrect language header",
        "English lemmas",
        "English multiword terms",
        "English nouns",
        "en:Databases"
      ],
      "glosses": [
        "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."
      ],
      "links": [
        [
          "database",
          "database"
        ],
        [
          "join",
          "join"
        ],
        [
          "record",
          "record"
        ]
      ],
      "raw_glosses": [
        "(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."
      ],
      "topics": [
        "computing",
        "databases",
        "engineering",
        "mathematics",
        "natural-sciences",
        "physical-sciences",
        "sciences"
      ]
    }
  ],
  "synonyms": [
    {
      "word": "full join"
    }
  ],
  "word": "full outer join"
}

This page is a part of the kaikki.org machine-readable English dictionary. This dictionary is based on structured data extracted on 2024-05-03 from the enwiktionary dump dated 2024-05-02 using wiktextract (f4fd8c9 and c9440ce). The data shown on this site has been post-processed and various details (e.g., extra categories) removed, some information disambiguated, and additional data merged from other sources. See the raw data download page for the unprocessed wiktextract data.

If you use this data in academic research, please cite Tatu Ylonen: Wiktextract: Wiktionary as Machine-Readable Structured Data, Proceedings of the 13th Conference on Language Resources and Evaluation (LREC), pp. 1317-1325, Marseille, 20-25 June 2022. Linking to the relevant page(s) under https://kaikki.org would also be greatly appreciated.