This caught me out once, big time. Now I know to filter out with the join clause.

Not that I intend on using that knowledge again for a long time!