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