>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!

I think you might need to use ...DELETED("Employee").

I think what might be happening is that DELETED() is examining the CURRENTLY SELECTED WORK AREA. So, if FooTable happens to be the currently selected table and the current record in FooTable is DELETED(), you get 'em all. If it's not DELETED(), you don't get any.

Basically, I believe this all goes back to the ancient adage about SELECT - SQL in making no assumptions about selected work areas etc. within the SELECT.