select para informes

[oscar2h]

lo soluciones, agregue una columna null as total_d

sera esa una solucion practica o correcta?

SELECT v.kn_id_venta, v.d_fecha_venta, v.h_hora_venta, v.n_num_boleta, v.kn_id_mesa, v.x_forma_pago,sum(n_precio*n_cantidad_venta) AS total, NULL as total_d
FROM detalle_venta AS dv
INNER JOIN ventas AS v ON dv.kn_id_venta= v.kn_id_venta
WHERE x_estado= 'Cerrado'
AND (v.d_fecha_venta BETWEEN '$fecha1' AND '$fecha2')
GROUP BY v.kn_id_venta, v.d_fecha_venta, v.h_hora_venta, v.n_num_boleta, v.kn_id_mesa, v.x_forma_pago
union ALL SELECT NULL,NULL,NULL,NULL,NULL,NULL,NULL, sum(n_precio*n_cantidad_venta) as total_d FROM detalle_venta AS dv
INNER JOIN ventas AS v
ON dv.kn_id_venta= v.kn_id_venta
WHERE x_estado= 'Cerrado' AND (v.d_fecha_venta BETWEEN '$fecha1' AND '$fecha2')