Why can't we do a JOIN instead of a subquery here?