Just in case: Oracle DB has 'null aware' joins. For instance: 'hash join anti na' which is a single join with two inputs.
I expect that databases can implement 'not in' semantics efficiently (at least they should be more efficient than enumerable) Vladimir
