Re: Boolean complement of a pair of OR clause

In <EHCFAI.6DG@nonexistent.com> Jacob Salomon <jake@garpac.com> writes: >WOW! That sounds like an esoteric topic! >select * from t2 > where number not in (select number from t1) > and name not in (select name from t1) >So what's the problem? To my chagrin, when I do this pair of WHERE >clauses against a much larger table (a customer table with thousands of >rows) the "valid row" query returns 0 rows. Without testing, I can't check it, but it sounds like the sort of wierdo result you get when nulls stick their grubby little hands into the pot. I don't know. Does 'number not in (<select which has some nulls>)' return true or false. I'll have to run one when I get a chance. Bryan Tonnet batonnet@phase4.com.au -- Bryan Tonnet batonnet@phase4.com.au