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