>Tried that too. What this does, though, is filters
>out records from the input file that don't have the
>120 code. I need all of the records from the input
>file, and just the matching link and code from the
>error file. The where zaps any records that aren't
>120's.

Keith,

So why do you have the "120" in the select at all? The first one sure looked like you only wanted error 120'as in the result. What is the goal? If it is to match the items from table1 to table2 and incldue all of table1, then this should work fine;

	?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 ;
			<strong>ON DataPPO.Fed_TaxId DataPPO.Tax_sufx = ;
                           dmlError.Fed_TaxId + dmlError.Tax_sufx ;</strong>
		INTO TABLE dmoPPO

Make sure there is an index on each table for Fed_taxid + tax_sufx for Rushmore.