search

ViniciusConsultor / controlhoras

Automatically exported from code.google.com/p/controlhoras
1 stars 0 forks source link

Listado de ExtrasLiquidacion #20

Closed GoogleCodeExporter closed 8 years ago

GoogleCodeExporter commented 8 years ago 
Listado de extras liquidacion

Original issue reported on code.google.com by juanga...@gmail.com on 14 Feb 2011 at 2:36

GoogleCodeExporter commented 8 years ago 
Pronto. Consulta que lo resuelve.

select emp.NroEmpleado, emp.Apellido, emp.Nombre, extra.Descripcion, 
if(extra.signo=0,'-','+') as Signo, cuotas.ValorCuota, 
cuotas.NumeroCuota,extra.CantidadCuotas from CuotasExtrasLiquidacion cuotas, 
Empleados emp, ExtrasLiquidacion extra where extra.IdEmpleado =emp.NroEmpleado 
and extra.IdExtraLiquidacion = cuotas.IdExtraLiquidacion and cuotas.Fecha 
between 'FECHADESDE' and 'FECHAHASTA'"

Original comment by juanga...@gmail.com on 14 Feb 2011 at 3:14

GoogleCodeExporter commented 8 years ago

Original comment by juanga...@gmail.com on 2 Apr 2011 at 11:21

GoogleCodeExporter commented 8 years ago

Original comment by juanga...@gmail.com on 21 Apr 2011 at 4:29