I have a SQL SELECT that I can't get to
optimize properly. I have a source table
from which I'm creating an output file in
the same format with some additional fields.

I am linking an error table that details the
exceptions in processing the main file.

There are no indexes on the input file, as the
input files are always processed sequentially.
I have several indexes on the error table
including Code, Fed_TaxId, and Tax_Sufx.

Below is my SQL statement:

	?SYS(3054,2)
	SELECT DataPPO.* ;
			, ReimbrsKey AS OldReimbrs ;
			, OtherId AS OldOtherId ;
			, DtToCompJul( MaintDate) AS MaintComp ;
			, DtToJul( MaintDate) AS MaintJul ;
			, dmlError.dm_Link ;
			, "K" AS StatusCode ;
			, DataPPO.Tax_Sufx AS Old_Sufx ;
			, .F. AS REPLACED ;
			, dmlError.CODE ;
		FROM DataPPO ;
		LEFT JOIN dmlError ;
			ON DataPPO.Fed_TaxId = dmlError.Fed_TaxId ;
				AND DataPPO.Tax_Sufx = dmlError.Tax_Sufx ; 
				AND dmlError.Code = "120" ;
		INTO TABLE dmoPPO

With the statement as is I get only partial
optimization. If I take out the "120" code
filter I get no optimization at all.

What the heck am I doing wrong???

advTHANKSance

...kt