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

O GOD! I started talking to myself :-)
I just want to edit my post :-)