Re: Boolean complement of a pair of OR clause

Bryan Tonnet wrote: ... SNIP ... > 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. Kazowwee!!! Kawabunga! (Does this mean anything?) I added a row to t1 with a null column and ran the same "valid row" query again. As with my live problem, it suddenly came up with 0 rows. When I added in the "where name/number is not null" clauses to the subqueries, it got me the rows I needed. Thanks, Bryan. That was it! I have just implemented that in the live query and it got the results I wanted. Of course, I could not do the insert and select in the same statement because SQL correctly will not let me insert into a table I am subquerying from. A select into temp followed by insert-select from the temp took care of that. -- -- Jake (In pursuit of undomesticated semi-aquatic avians) +---------------------------------------------------------------+ |Insofar as manifestations of functional deficiencies are agreed| |by any and all concerned parties to be imperceivable, and are | |so stipulated, it is incumbent upon said heretofore mentioned | |parties to exercise the deferment of otherwise pertinent | |maintenance procedures. | +--------------------------------------- (www.hardyharhar.com) -+