> Take a look at the IN clause. You may be able to formulate your query by doing
>something like this
>
>Select * from table where pkey not in ;
> (select col1, col2, col3 from table group by 2,3)
>
>This should return all records not selected in the 2nd query.
Yeah, I was going to suggest something like this, except that I was going to go with the original SELECT DISTINCT in the subquery....
Or, you could do a relation between the original table and the new table and COPY TO droppedRecs FOR EOF('newTable'). I suspect the straight SQL is better, though....