?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