Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- rrhh_planilla.idplanilla,
- rrhh_planilla.idtipoplanilla,
- rrhh_planilladetalle.idempleado,
- rrhh_empleado.nombre,
- rrhh_catpuesto.nombre AS Puesto,
- rrhh_empleado.fechaingreso,
- rrhh_planilla.fechapago,
- rrhh_planilladetalle.salario,
- rrhh_planilladetalle.bruto,
- SUM(rrhh_detallededucciones.valor) AS Tot_Ded,
- SUM(rrhh_detalledeingresos.valor) AS Tot_Ing,
- rrhh_planilladetalle.bruto + SUM(rrhh_detalledeingresos.valor) - SUM(rrhh_detallededucciones.valor) AS Neto
- FROM rrhh_planilladetalle
- LEFT JOIN rrhh_planilla ON rrhh_planilladetalle.idplanilla = rrhh_planilla.idplanilla
- LEFT JOIN rrhh_empleado ON rrhh_planilladetalle.idempleado = rrhh_empleado.idempleado
- LEFT JOIN rrhh_catpuesto ON rrhh_empleado.idpuesto = rrhh_catpuesto.Idpuesto
- LEFT JOIN rrhh_detallededucciones ON rrhh_detallededucciones.idplanilladetalle = rrhh_planilladetalle.idplanilladetalle
- LEFT JOIN rrhh_detalledeingresos ON rrhh_detalledeingresos.idplanilladetalle = rrhh_planilladetalle.idplanilladetalle
- WHERE rrhh_planilla.fechapago="2016-12-30" AND rrhh_planilla.idtipoplanilla="2"
- GROUP BY rrhh_planilladetalle.idplanilla, rrhh_planilladetalle.idempleado
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement