Another place to watch out for

... WHERE field NOT IN (SELECT field2 FROM tbl)

If field2 ever has a null value, this will always result in no selections.  It's funny, if that is never true you would think 'IN' would allways be true, but that one just compares the values.