Sergey is right, there is no join condition between appfile,userfile. I don't know why this SELECT works in development. Try:
SELECT appfile.PROCESSID, userfile.usernumber ;
FROM appfile
LEFT JOIN userfile ON AppFile.SomeJoinCondition == Userfile.SameJoinContition;
WHERE NOT STR(PROCESSID,6,0)+STR(usernumber,6,0) IN ;
(SELECT STR(PROCESSID,6,0)+STR(usernumber,6,0) FROM accessfile);
INTO CURSOR NewRecs READWRITE
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
