For NOT IN(...), use a straight exclusion join. The basic pattern is that ...