Hi Mark,

I wonder if it might work if you added a condition to the sub-select, along the lines of " where empid == customer.emp_num AND deleted()) ".

Good luck,

Jim N

>First, SET DELETED is OFF. Why does the following SQL not work?

>select cust_num, emp_num from customer ;
>   where customer.emp_num in ;
>   (select empid from employee where deleted())

>But the following will find the correct customer records:
>
>use employee order empid
>sele 0
>use customer
>set relation to emp_num into employee
>set filter to deleted("employee")
>locate
>
>TIA!