Hi Borislav,

Your code helps a little, but i need some more elements like documents Date, Code Movement, and the group by clause did not work,

take a look, it's not the defenitive query but have some new elements,

SELECT distinct a.c_cod_ter , 
SUM(CASE a.n_debcre WHEN 1 THEN a.n_val_doc ELSE 0 END) as cre,
SUM(CASE a.n_debcre WHEN 2 THEN a.n_val_doc ELSE 0 END) as deb,
a.d_data_doc, c.c_descri
FROM tbl_gc_MovimentosCCO a
 INNER JOIN tbl_gc_Clientes c
  ON a.c_cod_ter=c.c_codigo

WHERE a.n_tipo_ter=1 and a.c_cod_ter='00166'
GROUP BY a.c_cod_ter,a.d_data_doc, c.c_descri

UNION ALL

SELECT b.c_cod_ter,
CASE b.n_debcre WHEN 1 THEN b.n_val_doc ELSE 0 END as cre,
CASE b.n_debcre WHEN 2 THEN b.n_val_doc ELSE 0 END as deb,
b.d_data_doc, c.c_descri
FROM tbl_gc_MovimentosCCO b
 INNER JOIN tbl_gc_Clientes c
  ON b.c_cod_ter=c.c_codigo

WHERE b.n_tipo_ter=1 and b.c_cod_ter='00166'
ORDER BY c_cod_ter

João Batista