>Bruce,
>
>>I have some very large tables from which I have to get records NOT IN other very large tables. Code like this:
>
>>select * from table1;
>>where keyfield NOT IN;
>>(select keyfield from table2)
>
>how about
>
>USE TABLE1
>USE TABLE2 ORDER TAG keyfieldTag
>
>SET RELATION TO Keyfield INTO Table2
>
>BROWSE NORMAL FOR EOF("Table2")
>
>You might want to copy this into a temp table
>
>COPY TO Temptable *FOR* EOF("Table2")
Well, it was very fast until the COPY TO. Then it got almost completely stuck on COPY TO :(
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.