After some research, I found that NOT IN using a subquery will return zero rows if any null values are returned in your subquery. Here is an article with a...