Left Join
/left dʒɔɪn/
Definition
A SQL JOIN returning all rows from the left table and matching rows from the right — unmatched rows get NULL.
Example in context
"LEFT JOIN orders returns all users, including those with no orders — their order columns are NULL."
Related terms
Practice this term
Master Left Join in context by working through exercises in the Databases & SQL module. You'll see the term used in real engineering scenarios with multiple-choice, fill-in-the-blank, and matching drills.