Sergey --
I don't want a JOIN ... without a JOIN, I get all combinations of ProcessID from one table with UserNumber from the other table.
The AccessFile referenced in the first Select statement is supposed to contain all possible combination of processid (which comes from AppFile) and UserNumber (which comes from UserFile). I'm trying to get a list of all missing combinations.
The interesting thing is, these statements work just fine in development, but fail when a build an EXE. Why would that be?
Jim
>Jim,
>
>There's no JOIN condition between appfile and userfile tables in your select.
>
>>Any ideas why the second SQL statement here works fine in development, but fails on error 1814 in my EXE?
>>
SELECT STR(PROCESSID,6,0)+STR(usernumber,6,0) FROM accessfile INTO CURSOR Temp
>>
>>SELECT appfile.PROCESSID, userfile.usernumber ;
>> FROM appfile,userfile ;
>> WHERE NOT STR(PROCESSID,6,0)+STR(usernumber,6,0) IN ;
>> (SELECT * FROM Temp) ;
>> INTO CURSOR NewRecs READWRITE
>>
>>(I'm trying to find all combinations of ProcessID and UserNumber, both N(6), not already found in AccessFile.)
>>
>>Any suggested alternatives?
>>
>>Thanks
Jim Nelson
Newbury Park, CA