It's not a bug but incorrect use of DELETED() function. See Queries and functions which accept alias as parameter for details.

SET DELETE ON
		SELECT * FROM SourceDBF ;
			WHERE ;
			PRIN + Agent IN (SELECT PRIN + Agent FROM FAT_BASIC_AREAS_EXCLUSIONS) ;
			INTO CURSOR curToRemove NOFILTER

>


>I have a SQL query that I am trying to run and it will not return any records in the result set when I run it programatically. When I run the SQL command from the command line, it works fine. My workaround is to run the same query twice in a row. The first time it runs, nothing is returned, the second time it is run, I get the proper results.
>
>I know that this is a bug in VFP. How do I know that other queries that return an empty result aren't a result of a VFP bug? Has anyone else run into this problem? What did you do to resolve the issue?
>
>Here is the SQL:

>		SELECT * FROM SourceDBF ;
>			WHERE ;
>			PRIN + Agent IN (SELECT PRIN + Agent FROM FAT_BASIC_AREAS_EXCLUSIONS) AND ;
>			NOT DELETED() ;
>			INTO CURSOR curToRemove NOFILTER

>
>