>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.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.