See left outer join in All languages combined, or Wiktionary
{
"antonyms": [
{
"word": "right outer join"
}
],
"forms": [
{
"form": "left outer joins",
"tags": [
"plural"
]
}
],
"head_templates": [
{
"args": {},
"expansion": "left outer join (plural left 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": "other",
"name": "Pages with 1 entry",
"parents": [],
"source": "w"
},
{
"kind": "other",
"name": "Pages with entries",
"parents": [],
"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 \"right\"."
],
"hypernyms": [
{
"word": "outer join"
}
],
"id": "en-left_outer_join-en-noun-aLaui8xt",
"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 \"right\"."
],
"synonyms": [
{
"word": "left join"
}
],
"topics": [
"computing",
"databases",
"engineering",
"mathematics",
"natural-sciences",
"physical-sciences",
"sciences"
]
}
],
"word": "left outer join"
}
{
"antonyms": [
{
"word": "right outer join"
}
],
"forms": [
{
"form": "left outer joins",
"tags": [
"plural"
]
}
],
"head_templates": [
{
"args": {},
"expansion": "left outer join (plural left 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",
"Pages with 1 entry",
"Pages with entries",
"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 \"right\"."
],
"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 \"right\"."
],
"topics": [
"computing",
"databases",
"engineering",
"mathematics",
"natural-sciences",
"physical-sciences",
"sciences"
]
}
],
"synonyms": [
{
"word": "left join"
}
],
"word": "left outer join"
}
Download raw JSONL data for left outer join meaning in English (1.2kB)
This page is a part of the kaikki.org machine-readable English dictionary. This dictionary is based on structured data extracted on 2024-11-06 from the enwiktionary dump dated 2024-10-02 using wiktextract (fbeafe8 and 7f03c9b). 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.