>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())

HOw do you expect DELETED() to know which alias to check DELETED in? I made this mistake before, trying to use DELETED in a SQL query, and found that you can only depend on it when there is one and only one table involved in the query, so SLQ doesn't get confused. Also, specifying the alias: DELETED("Employee") doesn't work either... apparently something along the line breaks when you try to mix the VFP DML (DELETED()) with SQL.