>You need to turn on the SET DELETED before the SELECT-SQL and turn it back off after.
>
>HTH

---

>I have 3 table joining each other. I want to make an sql query. I use SET DELETED OFF
>>
>>I want to filter deleted records from main source table. But I donnot know how to do it. I consult to help file. It states, that it may product unpredictable result when using deleted(), but say nothing about solution.
>>How should I do it?

Dear Sylvain, I want to filter out deleted record from main source table only. The other two ones, also can contain deleted records, but data of these records must be visible in query result.

bb