Error |
Se produjo un error al acceder a la base de datos You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'JOIN sec_users u ON ra.usuario=u.login WHERE ra.folio=''' at line 1 SELECT ra.idvremabo as idvremabo, ra.idvrem as idvrem, ra.idctaf as idctaf, cf.nombre as cfnombre, ra.idcca as idcca, cca.nombre as ccanombre, ra.fecha as fecha, ra.importe as importe, ra.fp as fp, f.nombre as fpnombre, ra.usuario as usuario, ra.momento as momento, r.idalm as idalm, r.abonos as abonos, r.saldo as saldo, r.vence as vence, p.nombre as cte_nombre, p.razon as cte_razon, p.rfc as cte_rfc, p.identif as cte_identif, p.callenums as cte_callenums, p.col as cte_col, p.mpo as cte_mpo, p.edo as cte_edo, p.cp as cte_cp, p.tel as cte_tel, p.email as cte_email, ent.nombre as ent_nombre, ent.razon as ent_razon, ent.rfc as ent_rfc, ent.callenums as ent_callenums, ent.col as ent_col, ent.mpo as ent_mpo, ent.edo as ent_edo, ent.cp as ent_cp, ent.tel as ent_tel, ent.email as ent_email, r.idcte as cte_id, fm.formato as formato, fm.hint as hintformato, ra.cb as cb_cfdi, r.folio as folio, r.numpagos as numpagos, r.cantpagos as cantpagos, r.numpagos-r.cantpagos as pagospdtes, r.interestotal as interestotal, r.saldoinsoluto as saldoinsoluto, r.total-r.saldoinsoluto as renueva, p.numexpediente as numexpediente, ra.saldocurr as saldocurr, ra.saldocurr-ra.importe as saldopost, ra.folio as folioca, u.name as nomusuario from vremabo ra left join vrem r on ra.idvrem=r.idvrem left join person p on r.idcte=p.idperson left join alm alm on r.idalm=alm.idalm left join person a on alm.idperson=a.idperson LEFT JOIN ccfdi f ON ra.fp=f.clave AND tipo='f' LEFT JOIN ctaf cf ON ra.idctaf=cf.idctaf left join person ent on cf.idperson=ent.idperson LEFT JOIN cca cca ON ra.idcca=cca.idcca LEFT JOIN fmt fm ON fm.idfmt= LEFT JOIN sec_users u ON ra.usuario=u.login WHERE ra.folio='' |