Skip to content

Instantly share code, notes, and snippets.

@zafe
Created February 2, 2018 21:25
Show Gist options
  • Save zafe/f002b7b0336d7d108de24bc04d768295 to your computer and use it in GitHub Desktop.
Save zafe/f002b7b0336d7d108de24bc04d768295 to your computer and use it in GitHub Desktop.
SELECT
CONCEPTO_SUELDO.idCodigoConcepto,
CONCEPTO_SUELDO.descripcion,
CONCEPTO_SUELDO.cantidad,
CONCEPTO_SUELDO.tipo_concepto
FROM
CONCEPTO_SUELDO
INNER JOIN
TIPO_LIQUIDACION ON TIPO_LIQUIDACION.CONCEPTO_SUELDO_idCodigoConcepto = CONCEPTO_SUELDO.idCodigoConcepto
INNER JOIN
CATEGORIA_EMPLEADO ON CATEGORIA_EMPLEADO.idCategoriaEmpleado = TIPO_LIQUIDACION.CATEGORIA_EMPLEADO_idCategoriaEmpleado
INNER JOIN
EMPLEADO ON EMPLEADO.CATEGORIA_EMPLEADO_idCategoriaEmpleado = CATEGORIA_EMPLEADO.idCategoriaEmpleado
WHERE
EMPLEADO.idEmpleado = ?;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment