Sorry about the late response.

The select is querying from 2 tables, and I want the first table's undeleted records, and the 2nd tables deleted records.

Is this possible using a SELECT?

Thanks
Kev