SELECT appfile.PROCESSID, userfile.usernumber ;
FROM appfile
FULLJOIN userfile ON .t.;
WHERE NOT STR(PROCESSID,6,0)+STR(usernumber,6,0) IN ;
(SELECTSTR(PROCESSID,6,0)+STR(usernumber,6,0) FROM accessfile);
INTOCURSOR 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.