Quando eu executo esse fonte, trás o 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