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 'n' as tipo, r.idvrem as idvrem, r.idcte as idcte, r.fol' at line 1 select count(*), sum(cantpaq), sum(cantrem) from (SELECT k.tipo, k.idvrem, k.folio, k.ctenombre, k.idart, k.artnombre, k.cantrem, k.foliopaq, k.cantpaq, k.idvremdet FROM (select 'q' as tipo, r.idvrem as idvrem, r.idcte as idcte, r.folio as folio, p.nombre as ctenombre, d.idart as idart, a.nombre as artnombre, 0 as cantrem, q.folio as foliopaq, dq.cant as cantpaq, d.idvremdet as idvremdet from vremdetpaq dq left join paq q on dq.idpaq=q.idpaq left join vremdet d on dq.idvremdet=d.idvremdet left join art a on d.idart=a.idart left join vrem r on d.idvrem=r.idvrem left join person p on r.idcte=p.idperson where r.idvrem= UNION ALL select 'n' as tipo, r.idvrem as idvrem, r.idcte as idcte, r.folio as folio, p.nombre as ctenombre, d.idart as idart, a.nombre as artnombre, d.cant as cantrem, '' as foliopaq, 0 as cantpaq, d.idvremdet as idvremdet from vremdet d left join art a on d.idart=a.idart left join vrem r on d.idvrem=r.idvrem left join person p on r.idcte=p.idperson where r.idvrem= and d.idvremdet not in (select k.idvremdet from vremdetpaq k where k.idvremdet=d.idvremdet) ) k ) nm_sel_esp |