SQL trplicando resultado

Quando eu executo o seguinte fonte no SQL trás resultado triplicado


SELECT CN9_NUMERO AS ''''CONTRATO'''',
CONVERT(DATE, SUBSTRING(CN9_DTINIC, 1, 4) + ''''-'''' + SUBSTRING(CN9_DTINIC, 5, 2) + ''''-'''' + SUBSTRING(CN9_DTINIC, 7, 2)) AS ''''DT INICIO'''',
CONVERT(DATE, SUBSTRING(CN9_DTFIM, 1, 4) + ''''-'''' + SUBSTRING(CN9_DTFIM, 5, 2) + ''''-'''' + SUBSTRING(CN9_DTFIM, 7, 2)) AS ''''DT FIM'''',
CN9_NUMERO AS ''''CENTRO DE CUSTO'''',
CN9_ZZEMTI AS ''''ART EMITIDA'''',
CONVERT(DATE,CN9_ZZDTVA) AS ''''VALIDADE DA ART'''',
CN9_VLATU AS ''''VALOR CONTRATO'''',
CNC_CLIENT AS ''''CLIENTE'''',
CNC_LOJACL AS ''''LOJA CLIENTE'''',
A1_NOME AS ''''NOME CLIENTE'''',
CNE_PEDIDO AS ''''PEDIDO'''',
CNE_PERC AS ''''PERCENTUAL'''',
C6_NOTA AS ''''NOTA FISCAL'''',
E1_NUM AS ''''NUMERO'''',
CNE_REVISA,
CONVERT(DATE,E1_BAIXA) AS ''''DT BAIXA'''',
CNF_VLPREV AS ''''VALOR PREVISTO'''',
CNF_PARCEL AS ''''PARCELA'''',
CONVERT(DATE,CNF_DTVENC) AS ''''VENCIMENTO''''
FROM CN9010 CN9
INNER JOIN CNC010 CNC ON CNC.CNC_NUMERO = CN9.CN9_NUMERO AND CNC.D_E_L_E_T_ =''''''''
INNER JOIN SA1010 A1 ON CNC.CNC_CLIENT = A1.A1_COD AND CNC.CNC_LOJACL = A1.A1_LOJA AND A1.D_E_L_E_T_ =''''''''
INNER JOIN CNF010 CNF ON CNF.CNF_CONTRA = CN9.CN9_NUMERO AND CN9.D_E_L_E_T_=''''''''
INNER JOIN CNE010 CNE ON CNE.CNE_CONTRA = CNF.CNF_CONTRA AND CNE.D_E_L_E_T_=''''''''
INNER JOIN SC6010 C6 ON C6.C6_NUM = CNE.CNE_PEDIDO AND C6.D_E_L_E_T_ =''''''''
INNER JOIN SE1010 E1 ON E1.E1_NUM = C6.C6_NOTA AND E1.D_E_L_E_T_ ='''''''' AND E1.E1_TIPO =''''NF''''
WHERE CN9.D_E_L_E_T_=''''''''
AND CN9_NUMERO = ''''201000272''''
AND CN9_REVISA = ''''002''''
AND CN9.D_E_L_E_T_=''''''''
AND CNF_CONTRA = ''''201000272''''
AND CNF_REVISA = ''''002''''
AND CNF.D_E_L_E_T_=''''''''
AND CNE_CONTRA = ''''201000272''''
AND CNE_REVISA = ''''002''''
AND CNE.D_E_L_E_T_=''''''''
AND E1_PREFIXO = ''''SRV''''
AND CNC_NUMERO = ''''201000272''''
AND CNC_REVISA = ''''002''''


GROUP BY CN9_NUMERO,CN9_REVISA,CN9_DTINIC,CN9_DTFIM,CN9_NUMERO,CN9_ZZEMTI,CN9_ZZDTVA,CN9_VLATU,CNC_CLIENT,CNC_LOJACL, A1_NOME, CNE_PEDIDO, CNE_PERC, C6_NOTA, E1_NUM, CNE_REVISA, E1_BAIXA, CNF_VLPREV, CNF_PARCEL, CNF_DTVENC