select k.id_pack, m.FECHA, m.NUMSUC, m.NUMDOC, m.TOTAL as Total_FC, Sum(ifnull(f.total, 0)) as Total_RC, h.PAGO FROM enlaces_pack k INNER JOIN enlaces_pedido p on k.Id_pedido = p.Id_pedido inner join MOV_CLIENTES m on p.id = m.Id inner join FECHAS_VENTAS h on m.Id = h.Id left join enlaces_factura f on p.id = f.Id_factura WHERE p.doc < 4 and k.id_pack = '338' GROUP BY k.id_pack, m.FECHA, m.NUMSUC, m.NUMDOC, m.TOTAL, h.PAGO ********************************************************************************************************** select k.id_pack, c.FECHA , c.NUMSUC, c.NUMDOC , m.FECHA, m.NUMSUC, m.NUMDOC, m.TOTAL as Total_FC, Sum(ifnull(f.total, 0)) AS Total_RC, h.PAGO, t.pedido, t.E1 , t.fc , t.E5 FROM enlaces_pack k INNER JOIN enlaces_pedido p on k.Id_pedido = p.Id_pedido inner join DOC_PEDIDOS c on p.Id_pedido = c.Id inner join MOV_CLIENTES m on p.id = m.Id inner join FECHAS_VENTAS h on m.Id = h.Id inner join doc_pedidos_totales t on p.Id_pedido = t.id_pedido left join enlaces_factura f on p.id = f.Id_factura WHERE p.doc < 4 and k.id_pack = '338' GROUP BY k.id_pack, m.FECHA, m.NUMSUC, m.NUMDOC, m.TOTAL, h.PAGO ********************************************************************************************************* select k.id_pack, sum(pedido-E1), sum(pedido-E5), sum(pedido-fc), pago FROM enlaces_pack k INNER JOIN enlaces_pedido p on k.Id_pedido = p.Id_pedido inner join FECHAS_VENTAS h on m.Id = h.Id inner join doc_pedidos_totales t on p.Id_pedido = t.id_pedido WHERE p.doc < 4 and k.id_pack = '338' GROUP BY k.id_pack, m.FECHA, m.NUMSUC, m.NUMDOC, m.TOTAL, h.PAGO ********************************************************************************************************* select k.id_pack, sum(pedido) as pedido, sum(t.E1) as recepcion, sum(t.pedido-t.E5) as entrega, sum(t.pedido-t.fc) as factura FROM enlaces_pack k INNER JOIN doc_pedidos_totales t on k.Id_pedido = t.id_pedido where k.id_pack = '338' group by k.id_pack ********************************************************************************************************* select k.id_pack, sum(t.E0)/sum(t.pedido)*100 as nulo, sum(t.pedido) as pedido, sum(t.E1)/(sum(t.pedido)-sum(t.E0))*100 as recepcion, sum(t.E5)/(sum(t.pedido)-sum(t.E0))*100 as entrega, sum(t.fc)/(sum(t.pedido)-sum(t.E0))*100 as factura FROM enlaces_pack k INNER JOIN doc_pedidos_totales t on k.Id_pedido = t.id_pedido where k.id_pack = '338' group by k.id_pack ********************************************************************************************************* select k.id_pack, sum(pedido) as pedido, sum(t.E1) as recepcion, sum(t.E5) as entrega, sum(t.fc) as factura FROM enlaces_pack k INNER JOIN doc_pedidos_totales t on k.Id_pedido = t.id_pedido where k.id_pack = '338' group by k.id_pack ********************************************************************************************************* select k.id_pack, sum(pedido) as pedido, sum(t.E1) as recepcion, sum(t.E5) as entrega, sum(t.fc) as factura, Sum(ifnull(f.total, 0)) AS Total_RC FROM enlaces_pack k INNER JOIN doc_pedidos_totales t on k.Id_pedido = t.id_pedido INNER JOIN enlaces_pedido p on k.Id_pedido = p.Id_pedido left join enlaces_factura f on p.id = f.Id_factura where k.id_pack = '338' and p.doc < 4 group by k.id_pack ********************************************************************************************************* BEGIN UPDATE doc_pedidos_totales SET fc_importe = fc_importe + NEW.total_final where id_pedido = NEW.id_doc_p and NEW.CANTIDAD > 0; UPDA select k.id_pack, sum(p.cantidad*p.precio*(1+p.tasa_iva)) as pedido, sum(p.cantidad*p.precio*(1+p.tasa_iva)) as pedido FROM enlaces_pack k INNER JOIN PEDID_PARAM_ARTICULOS p on k.id_pedido = p.id_doc inner join ETAPAS_TRZ_MOVIMIENTOS m on p.id = m.id_art where k.id_pack = '338' group by k.id_pack 65866.0475 select p.Id_pedido, v.fecha, v.numsuc, v.numdoc, v.TOTAL_FINAL, f.doc from enlaces_pedido p inner join DOC_VENTAS v on p.id = v.id LEFT join enlaces_factura f on v.id = f.id_factura where p.doc < 4 and f.doc > 17 and ISNULL(f.DOC)