SQL - La consulta trae mas datos de los que debería taer

SELECT SUB.HOR_ENT,  MAX (CT.HOR_RELO)HOR_SAL, CT.FEC_SIST, CT.COD_EMPL, CT.RMT_SROF

  FROM NM_CTRRE CT, (SELECT  MIN (HOR_RELO)HOR_ENT, FEC_SIST, COD_EMPL FROM NM_CTRRE  WHERE TIP_MOVI = 'E' GROUP BY FEC_SIST, COD_EMPL ) SUB

 WHERE CONVERT(varchar(10), CT.FEC_SIST, 110) = CONVERT(varchar(10), SUB.FEC_SIST, 110)

   AND CT.COD_EMPL = SUB.COD_EMPL

   AND CT.COD_EMPL = 666666

   AND TIP_MOVI = 'S'

   AND CT.FEC_SIST >= '20140501'

   AND CT.FEC_SIST <=  '20140520'

GROUP BY SUB.HOR_ENT, CT.FEC_SIST, CT.COD_EMPL, CT.RMT_SROF

ORDER BY CT.FEC_SIST

SELECT SUB.HOR_ENT,

       CT.HOR_SAL ,

	   CT.FECHA   ,

	   CT.COD_EMPL,

	   CT.RMT_SROF

FROM  (SELECT MIN(HOR_RELO) AS HOR_SAL,

	          CONVERT(varchar(10), FEC_SIST, 110) AS FECHA,

			  COD_EMPL,

			  RMT_SROF

	   FROM   NM_CTRRE

	   WHERE  TIP_MOVI = 'S'

	   GROUP  BY CONVERT(varchar(10), FEC_SIST, 110)

	          , COD_EMPL

			  , RMT_SROF

	  ) SUB

      (SELECT MIN(HOR_RELO) AS HOR_ENT,

	          CONVERT(varchar(10), FEC_SIST, 110) AS FECHA,

			  COD_EMPL,

			  RMT_SROF

	   FROM   NM_CTRRE

	   WHERE  TIP_MOVI = 'E'

	   GROUP  BY CONVERT(varchar(10), FEC_SIST, 110)

	          , COD_EMPL

			  , RMT_SROF

	  ) SUB

WHERE CT.FECHA = SUB.FECHA

AND   CT.COD_EMPL = SUB.COD_EMPL

AND   CT.RMT_SROF = SUB.RMT_SROF

AND   CT.COD_EMPL = 666666

AND   CT.FEC_SIST >= '20140501'

AND   CT.FEC_SIST <= '20140520'

SELECT MAX(HOR_RELO)HOR_SAL, MIN(HOR_RELO)HOR_ENT, CONVERT(date, FEC_SIST, 110) as FEC_SIST,

       COD_EMPL, RMT_SROF

  FROM NM_CTRRE

 WHERE TIP_MOVI IN ('E' , 'S')

   AND COD_EMPL = 79545352

   AND FEC_SIST >= '20100101'

   AND FEC_SIST <=  '20140521'

GROUP BY CONVERT(date, FEC_SIST, 110), COD_EMPL, RMT_SROF

ORDER BY FEC_SIST

SELECT MAX(HOR_RELO)HOR_SAL, MIN(HOR_RELO)HOR_ENT

                 , TO_CHAR(FEC_SIST, 'DD-MM-YYYY') as FEC_SIST

, COD_EMPL, RMT_SROF

FROM NM_CTRRE

 WHERE TIP_MOVI IN ('E' , 'S')

AND COD_EMPL = 79545352

AND FEC_SIST >= TO_DATE('20100101', 'YYYMMDD') 

AND FEC_SIST <= TO_DATE('20140521', 'YYYYMMDD')

GROUP BY

TO_CHAR(FEC_SIST, 'DD-MM-YYYY') as FEC_SIST,

COD_EMPL, RMT_SROF

ORDER BY FEC_SIST