"right outer join" meaning in English

See right outer join in All languages combined, or Wiktionary

Noun

Forms: right outer joins [plural]
Head templates: {{en-noun}} right outer join (plural right outer joins)
  1. (databases) A join yielding a set of records for two tables, where all rows of the "right" table are enlisted with all rows of the "left" table, even if the join condition does not find any matching row on the "left". Categories (topical): Databases Synonyms: right join Hypernyms: outer join
    Sense id: en-right_outer_join-en-noun-afw3JHr5 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 right outer join meaning in English (1.4kB)

{
  "antonyms": [
    {
      "word": "left outer join"
    }
  ],
  "forms": [
    {
      "form": "right outer joins",
      "tags": [
        "plural"
      ]
    }
  ],
  "head_templates": [
    {
      "args": {},
      "expansion": "right outer join (plural right 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 \"right\" table are enlisted with all rows of the \"left\" table, even if the join condition does not find any matching row on the \"left\"."
      ],
      "hypernyms": [
        {
          "word": "outer join"
        }
      ],
      "id": "en-right_outer_join-en-noun-afw3JHr5",
      "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 \"right\" table are enlisted with all rows of the \"left\" table, even if the join condition does not find any matching row on the \"left\"."
      ],
      "synonyms": [
        {
          "word": "right join"
        }
      ],
      "topics": [
        "computing",
        "databases",
        "engineering",
        "mathematics",
        "natural-sciences",
        "physical-sciences",
        "sciences"
      ]
    }
  ],
  "word": "right outer join"
}
{
  "antonyms": [
    {
      "word": "left outer join"
    }
  ],
  "forms": [
    {
      "form": "right outer joins",
      "tags": [
        "plural"
      ]
    }
  ],
  "head_templates": [
    {
      "args": {},
      "expansion": "right outer join (plural right 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 \"right\" table are enlisted with all rows of the \"left\" table, even if the join condition does not find any matching row on the \"left\"."
      ],
      "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 \"right\" table are enlisted with all rows of the \"left\" table, even if the join condition does not find any matching row on the \"left\"."
      ],
      "topics": [
        "computing",
        "databases",
        "engineering",
        "mathematics",
        "natural-sciences",
        "physical-sciences",
        "sciences"
      ]
    }
  ],
  "synonyms": [
    {
      "word": "right join"
    }
  ],
  "word": "right 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-04-30 from the enwiktionary dump dated 2024-04-21 using wiktextract (210104c 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.