left join

A form of left outer join — 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".

Opposite
right join
Ask AI about this wordChatGPTClaudePerplexityGoogle AIGrok

Meanings

nounleft join (plural left joins)

plural left joins

  1. abbreviationellipsiscomputingEllipsis of left outer join.

Synonyms & antonyms

Also see
left outer join
Cite this entry
APA

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

MLA

“left join.” WatkinsX Dictionary, https://dictionary.watkinsx.com/word/left%20join. Accessed November 2, 2026.

Chicago

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

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