Following are the tables structures: TABLE INDICES ------------------ CREATE TABLE `indices` ( `DocumentID` int(11) NOT NULL default '0', `Id_base_datos` int(11) NOT NULL default '0', `Numero_Documento` char(20) character set latin1 collate latin1_spanish_ci default NULL, `Fecha_Contabilidad` char(10) character set latin1 collate latin1_spanish_ci default NULL, `Numero_Anulacion` decimal(18,0) default NULL, `Fecha_Anulacion` char(10) character set latin1 collate latin1_spanish_ci default NULL, `Archivo` decimal(18,0) default NULL, `Modulo` char(2) character set latin1 collate latin1_spanish_ci default NULL, `Entrepano` char(2) character set latin1 collate latin1_spanish_ci default NULL, `Fecha_digitalizado` char(10) character set latin1 collate latin1_spanish_ci default NULL, `Digitalizado_por` char(50) character set latin1 collate latin1_spanish_ci default NULL, `Numero_de_Caja` int(11) default NULL, `Anio` int(11) default NULL, `estatus` char(1) character set latin1 collate latin1_spanish_ci NOT NULL default '', KEY `index_1` (`DocumentID`,`Id_base_datos`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; Table SAP: ---------------- CREATE TABLE `sap` ( `no_Doc` varchar(20) collate utf8_spanish_ci default NULL, `fecha` varchar(20) collate utf8_spanish_ci default NULL, KEY `no_Doc` (`no_Doc`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;