Hi Naomi,

It work's, sorry i try to group with cNomFor, the working one, now try with real data.

select c_cod_art,min(cNomFor) as cNomFor,
       SUM(CASE n_terceiro WHEN 1 THEN n_quant ELSE 0 END) as QtCli,
       SUM(CASE n_terceiro WHEN 2 THEN n_quant ELSE 0 END) as QtFor
from  #mov_enc_plano
group by c_cod_art
order by c_cod_art