>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...
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.