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 EOF("Table2")

Walter,