
April 29th, 2003, 07:48 AM
|
 |
Contributing User
|
|
Join Date: Jul 2002
Posts: 123
Time spent in forums: 2 h 51 m 51 sec
Reputation Power: 6
|
|
|
FoxPro query length limit
Hi,
I have 2 tables (in different DBs: Access2000 and FoxPro 6) holding Employee's data. I need to extract all the records records from 1 table which DO NOT exisy in the other.
I've tried using something like this:
SELECT E.Data FROM tblEmployee E
WHERE E.EMPLOYEE NOT IN ("%0", "%12452").
The list in the 'NOT IN' is extracted from the other table.
The problem is that when that list gets more than 24 elements long FoxPro comes out with a 'SQL expression is too complex' error.
Any idea how to solve the problem? (I've tried braking the querys into 24 items long but it retrieves duplicates values).
Thanx
|