What happens to Bob with no department?

Question

Accepted Answer

LEFT JOIN keeps every row from the left table (employees) regardless of whether a match exists in the right table. Alice matches Sales. Bob has no dept_id, so no department row matches - the dept column is NULL in his result row. Use LEFT JOIN when you need all left-table rows even if the right side has no data.