Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT IFNULL(s.id_servicio,'Total') AS
- id_servicio,IFNULL(s.fecha_servicio,'General') AS
- fecha_servicio,c.nombre_conductor,c.apellido_conductor,
- d.nombre_distrito,u.nombre_urbanizacion,SUM(s.precio) AS
- precio,ds.nombre_tipo FROM servicios s
- INNER JOIN distrito d ON s.id_distrito = d.id_distrito
- INNER JOIN urbanizacion u ON s.id_urbanizacion = u.id_urbanizacion
- INNER JOIN conductor c ON s.id_conductor = c.id_conductor
- INNER JOIN detalle_servicio ds ON s.tipo_servicio = ds.tipo_servicio
- WHERE c.id_conductor = $i_conductor AND s.fecha_servicio BETWEEN
- '$i_fecha_inicio_format2' AND '$i_fecha_fin_format2' GROUP BY
- s.fecha_servicio,s.id_servicio ASC WITH ROLLUP
- <https://i.stack.imgur.com/nwk4B.png>
Add Comment
Please, Sign In to add comment