I was taught to stay away from "in" and "not in" and that "exists" and "not exists" is faster and in this case more reliable. When I changed the query to :

Select a

From...