This may have been mentioned already, but is there an index on agent_num?


>>Patrick,
>>Queries with subqueries are expected to run slow. There was a discussion about this and showing why an "IN" query would be much slower on fox4um.com (but I'm afraid it's in Turkish).
>>I'd use an inner join or xbase.
>>Cetin
>
>Are you able to share the basic concept that was discussed of why an "IN" query would be expected to be slower in fox? It is not the case in other databases (MSSQL or DB2).
>
>Thanks.