>I know I'm going to catch hell for suggesting using the deleted mark but this will work fast.
>
>DELETE FROM table1 WHERE keyfield IN (SELECT keyfield FROM table2)
>SELECT * FROM table1 WHERE !DELETED()

Actually that's a rather clever idea, and there are no deleted records in these tables, so that is not an obstacle for this idea.

The problem is doing RECALL ALL later - that may take a long while, and I don't want to do a COPY TO here. But I will test it along with Walter's idea, to see how these ideas go...