In that case I will issue the following:

SET DELETED OFF
SELECT * FROM table2 INTO CURSOR table2_all

Then issue my other select to bring across the deleted records.

This should work OK, shouldn't it?

THanks
Kev