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.)
SELECT appfile.PROCESSID, userfile.usernumber ; FROM appfile,userfile ; WHERE NOT BINTOC(PROCESSID)+BINTOC(usernumber) IN ; (SELECT BINTOC(PROCESSID)+BINTOC(usernumber) FROM accessfile) ; INTO CURSOR NewRecs READWRITE2.TRY ( but it can to be slower ):
SELECT appfile.PROCESSID, userfile.usernumber ; FROM appfile,userfile ; LEFT JOIN accessfile acc ON ACC.PROCESSID=appfile.PROCESSID AND ACC.usernumber = userfile.usernumber; WHERE ACC.PROCESSID IS NULL; INTO CURSOR NewRecs READWRITE