09-02-2023, 05:14 PM
Gracias ,pero entro en ventas y me sale
select round(sum(vc.cantidad * (vc.precio + ((vc.precio * vc.avgiva)/100) + ((vc.precio * vc.impuesto2)/100))-((vc.cantidad * (vc.precio + ((vc.precio * vc.avgiva)/100) + ((vc.precio * vc.impuesto2)/100)) * descuento)/100)),2) as sumatotal from ventadir_comg vc where id_venta in (select id_venta from ventadirecta where id_tiquet in (select id_tiquet from tiquet where id_tiquet is not null and serie = "F" and fecha_tiquet>='2023-02-09' and fecha_tiquet<='2023-02-09' and horatiquet>='00:00:00' and horatiquet<='23:59:59') and serie = "F")
si lo actualizo se ira ?
select round(sum(vc.cantidad * (vc.precio + ((vc.precio * vc.avgiva)/100) + ((vc.precio * vc.impuesto2)/100))-((vc.cantidad * (vc.precio + ((vc.precio * vc.avgiva)/100) + ((vc.precio * vc.impuesto2)/100)) * descuento)/100)),2) as sumatotal from ventadir_comg vc where id_venta in (select id_venta from ventadirecta where id_tiquet in (select id_tiquet from tiquet where id_tiquet is not null and serie = "F" and fecha_tiquet>='2023-02-09' and fecha_tiquet<='2023-02-09' and horatiquet>='00:00:00' and horatiquet<='23:59:59') and serie = "F")
si lo actualizo se ira ?