Last night I had another instance where doing a:
SELECT * FROM
TBL WHERE ID NOT IN (SELECT ID FROM TBL2)
would fail every time to return any rows.
After longer than it should have been, I realized that it was this stupid issue that I blogged about already (SQL “NOT IN” Will Fail If The List Contains A Null).