Keith,

Try these changes;

Create indexes on DataPPO for Fed_taxid and Tax_sufx to allow optimization. You don't ever have to use these indexes yourself but Rushmore needs them. Then restructure your select to the one below;

	?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 ;
                <strong>WHERE dmlError.Code = "120" ;</strong>
		INTO TABLE dmoPPO