Skip to content

Instantly share code, notes, and snippets.

@MarioCares

MarioCares/licencias_para_rita.sql

Created October 26, 2017 19:21
Show Gist options
  • Save MarioCares/024372abf0944a8ceaacd9fc50c39a65 to your computer and use it in GitHub Desktop.
Save MarioCares/024372abf0944a8ceaacd9fc50c39a65 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
licencias_para_rita.sql
SELECT l.rut, l.dv, l.nombres, l.tipo_calculo AS calidad, l.centro_costo, l.cargo, l.docente, l.lugar_desempenio
FROM rrhh_licencia AS rl
INNER JOIN liquidaciones AS l ON l.rut = rl.usuario_id
WHERE rl.estado != 'ELIMINADO' AND DATE_FORMAT(rl.inicio_at, '%Y-%m') = '2017-09' AND l.area = 'EDUCACION' AND l.aniomes = 201709
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment