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 'WHERE m.folio=''' at line 1 SELECT m.idmovctaf as idmovctaf, m.nombre as movdesc, m.idctaf as idctaf, cf.nombre as cfnombre, m.idcca as idcca, cca.nombre as ccanombre, m.fecha as movfecha, m.fp as fp, fp.nombre as fpnombre, m.importe as movimporte, m.usuario as usuario, m.momento as momento, v.idvrem as idvrem, v.idcte as idcte, v.idalm as idalm, v.fecha as fecha, v.subtotal as subtotal, v.iva as iva, v.ieps as ieps, v.total as total, dia.nombre as diavisita, perp.nombre as perpago, v.numpagos as numpagos, v.aboper as aboper, v.inipago as inipago, v.vence as vence, v.impcred as impcred, v.comis as comis, v.cargos as cargos, v.abonos as abonos, v.saldo as saldo, cte.nombre as cte_nombre, cte.razon as cte_razon, cte.rfc as cte_rfc, cte.callenums as cte_callenums, cte.col as cte_col, cte.mpo as cte_mpo, cte.edo as cte_edo, cte.cp as cte_cp, cte.tel as cte_tel, cte.email as cte_email, ent.nombre as alm_nombre, ent.razon as alm_razon, ent.rfc as alm_rfc, ent.callenums as alm_callenums, ent.col as alm_col, ent.mpo as alm_mpo, ent.edo as alm_edo, ent.cp as alm_cp, ent.tel as alm_tel, ent.email as alm_email, fm.formato as formato, fm.hint as hintformato, m.notas as notas from movctaf m LEFT JOIN ctaf cf ON m.idctaf=cf.idctaf LEFT JOIN vrem v ON m.idvrem=v.idvrem LEFT JOIN cca cca ON m.idcca=cca.idcca LEFT JOIN person cte ON v.idcte=cte.idperson LEFT JOIN alm a ON v.idalm=a.idalm LEFT JOIN person ent ON a.idperson=ent.idperson LEFT JOIN ccfdi fp ON m.fp=fp.clave and fp.tipo='f' LEFT JOIN ccfdi dia ON v.diavisita=dia.clave AND dia.tipo='d' LEFT JOIN ccfdi perp ON v.perpago=perp.clave AND perp.tipo='p' LEFT JOIN fmt fm ON fm.idfmt= WHERE m.folio='' |