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