I corrected the code. Man, it is difficult to code after a late lunch and in this heat. Our air conditioner is not cutting it in this California heat.
SELECT ;
cFileName ;
FROM tmpPDFFileNames ;
WHERE tmpPDFFileNames.cFileName NOT IN (SELECT cFileName FROM SCAN) ;
INTO CURSOR tmpPDFs