>>select * from table1;
>>where keyfield NOT IN;
>>(select keyfield from table2)
Hey, this is an old thread :-)
Thanks guys, but the fastest solution (with careful testing and analysis on large tables), was found to be NOT INDEXSEEK(). No SQL involved, and I think Walter came up with that idea.
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.