SELF-GUIDED BA PRACTICE Packages available · Access after confirmed paymentSee packages ↗

Business analysis glossary

Left Join

What it is

A left join returns every row from the left table and the matching rows from the right table. Where no match exists, the right table's columns come back empty, shown as NULL. It is written as LEFT JOIN in SQL and is used when you must keep all rows from the first table.

Why it matters

Choosing the wrong join is one of the most common reasons query results are wrong. An inner join silently drops rows with no match, while a left join keeps them, which is often exactly what an analyst needs to find gaps, such as customers with no orders or claims with no payment.

Example

To find policyholders who have never made a claim, the analyst writes a left join from policies to claims and keeps rows where the claim id is NULL. An inner join would have returned only policyholders with claims and hidden the very customers she was looking for.

Used in these guides

CHECK BEFORE CONTINUING

Keep your work safe