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 v.foliodcto=''' at line 1 SELECT v.idvped as idvped, v.idcte as idcte, v.idalm as idalm, v.idpromo as idpromo, v.idctaf as idctaf, v.idruta as idruta, v.idloca as idloca, v.idces as idces, v.fecha as fecha, v.subtotal as subtotal, v.iva as iva, v.ieps as ieps, v.total as total, v.mp as mp, v.fp as fp, mp.nombre as mpnombre, fp.nombre as fpnombre, v.usuario as usuario, v.fechaupd as fechaupd, v.pv as pv, v.estatus as estatus, 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.identif as cte_identif, cte.email as cte_email, alm.nombre as alm_nombre, alm.razon as alm_razon, alm.rfc as alm_rfc, alm.callenums as alm_callenums, alm.col as alm_col, alm.mpo as alm_mpo, alm.edo as alm_edo, alm.cp as alm_cp, alm.tel as alm_tel, alm.email as alm_email, fm.formato as formato, fm.hint as hintformato, fm.det1 as det1, fm.det2 as det2, fm.det3 as det3, fm.det4 as det4, fm.det5 as det5, fm.det6 as det6, fm.det7 as det7, fm.det8 as det8, fm.esp1 as esp1, fm.esp2 as esp2, fm.esp3 as esp3, fm.esp4 as esp4, fm.esp5 as esp5, fm.esp6 as esp6, fm.esp7 as esp7, fm.esp8 as esp8, ces.nombre as cesnombre, promo.nombre as promonombre, ruta.nombre as rutanombre, ctaf.nombre as ctafnombre, fm.lineas_det as lineas_det, fm.pag2 as pag2, fm.formato2 as formato2, cte.numexpediente as numexpediente, v.observaciones as observaciones, v.momento as momento, v.folio as folio, v.statdcto as statdcto, v.foliodcto as foliodcto, fm.printexist as printexist, v.fechaxauto as fechaxauto, v.fechaauto as fechaauto, v.canttot as canttot from vped v LEFT JOIN person cte ON v.idcte=cte.idperson LEFT JOIN alm a ON v.idalm=a.idalm LEFT JOIN ces ON v.idces=ces.idces LEFT JOIN ruta ON v.idruta=ruta.idruta LEFT JOIN person promo ON v.idpromo=promo.idperson LEFT JOIN person alm ON a.idperson=alm.idperson LEFT JOIN ccfdi mp ON v.mp=mp.clave and mp.tipo='m' LEFT JOIN ccfdi fp ON v.fp=fp.clave and fp.tipo='f' LEFT JOIN ctaf ON v.idctaf=ctaf.idctaf LEFT JOIN fmt fm ON fm.idfmt= WHERE v.foliodcto='' |