"Which trainers own no Codémon at all?" is a very common question, and LEFT JOIN answers it in two steps: keep every trainer, then keep only the rows where nothing was attached.
↗️
Loading editor...
↶
↷
A real match always carries a Codémon with a codemon_id; only the unmatched rows have NULL there. The WHERE ... IS NULL keeps exactly those. This pattern is often called an anti-join.
Test a column that can never be NULL
Use the primary key of the right table in the IS NULL test. A column like capture_date could be NULL on a real match too, and you would get false positives.