>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

I haven't tried this code, but you could try something like:

SET DELETED OFF
SELECT Field1, Field2 ;
FROM Table1 JOIN Table2 ON Table1.Field3 = Table2.Field4 ;
WHERE !DELETED("Table1") ;
AND DELETED("Table2")

If that doesn't work, you can use two SQL SELECT statements.