gRACIAS YA LO HICE
ESTE SERIA EL CODIGO
Código SQL:
Ver originalSELECT B.COD_TRABAJADOR,B.COD_CONCEPASIST,A.ANO,A.MES,A.SEMANA,B.CANTIDAD AS HORAS
FROM RH_PLANILLA_MENSUAL_CABECERA A, RH_REGISTRO_HORAS B
WHERE A.TIP_PLANILLA='E' AND A.COD_CLASE_PLANILLA='01' AND A.FLG_STATUS_PLANILLA='L'
AND A.ANO+A.MES>='201207'
AND A.ANO+A.MES<='201408'
AND A.TIP_PLANILLA=B.TIP_PLANILLA AND A.NUM_CORRE_PLANILLA=B.NUM_CORRE_PLANILLA AND B.COD_CONCEPASIST IN ('AS01','HE01','HE02','HE03') AND B.Cod_Trabajador='0165'
ORDER BY B.COD_TRABAJADOR,A.ANO,A.MES,A.SEMANA,B.COD_CONCEPASIST