An inner join quietly drops rows that have no match, like departments with no employees. LEFT JOIN keeps every row from the left table and fills the right side with NULL when nothing matches. Use it for questions like "list every department and its headcount, including empty ones". Adding WHERE right.id IS NULL turns it into "rows with no match", a very common interview pattern.