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!