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 ') UNION ALL SELECT v.idvrem as idvrem, v.folio as folio, p.nombre as no' at line 1 select count(*) from (SELECT v.idvrem as idvrem, v.folio as folio, p.nombre as nombre, v.saldo as saldo, COALESCE(r.idfmtedocta,0) as idfmtedocta, COALESCE(r.idfmtpago,0) as idfmtpago, concat('WHERE v.idvrem=',v.idvrem) as vwhereedocta, v.idalm as idalm, v.idctaf as idctaf, v.idpromo as idpromo, v.foliodcto as foliodcto, COALESCE(r.nombre,'Sin ruta designada') as rutanombre, v.recib_momen as recib_momen, v.recib_folio as recib_folio, v.recib_notas as recib_notas, v.vence as vence, v.impvenc as impvenc, v.usuario as usuario, v.total-v.impfrenov as aentregar FROM vrem v INNER JOIN person p ON v.idcte = p.idperson LEFT JOIN ruta r ON v.idruta = r.idruta WHERE v.saldo>0 AND ((p.identif='' AND p.identif<>'0' AND p.identif<>'') OR v.idcte=) UNION ALL SELECT v.idvrem as idvrem, v.folio as folio, p.nombre as nombre, v.saldo as saldo, COALESCE(r.idfmtedocta,0) as idfmtedocta, COALESCE(r.idfmtpago,0) as idfmtpago, concat('WHERE v.idvrem=',v.idvrem) as vwhereedocta, v.idalm as idalm, v.idctaf as idctaf, v.idpromo as idpromo, v.foliodcto as foliodcto, COALESCE(r.nombre,'Sin ruta designada') as rutanombre, v.recib_momen as recib_momen, v.recib_folio as recib_folio, v.recib_notas as recib_notas, v.vence as vence, v.impvenc as impvenc, v.usuario as usuario, v.total-v.impfrenov as aentregar FROM vrem v INNER JOIN person p ON v.idcte = p.idperson LEFT JOIN ruta r ON v.idruta = r.idruta WHERE v.saldo<=0 AND ((p.identif='' AND p.identif<>'0' AND p.identif<>'') OR v.idcte='') ) nm_sel_esp |