>>Hi Borislav,
>>
>>Hi know there are something diferent, n_terceiro like Sergey observe, but for display purpose i need only one row, like,
>>
>>

>>the query gives (SQL Server)
>> c_cod_art .... qtCli ... qtFor
>>----------------------------------
>>   AAAA           10        0
>>   AAAA            0        5
>>
>>i need,
>>
>>   AAAA           10        5
>>

>>
>>or another query based on first, to give only one row,
>>
>>João Batista
>
>Then don't include other columns in the query.Group only for c_cod_art and add SUM() columns, exclude all others from the query.

select c_cod_art
       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