here is the final release.. working

SELECT SUM(Cc.total), SUM(Cc.qtde), Cc.codigo;
 FROM cur_products as cc;
 GROUP BY Cc.codigo;
 ORDER BY 1 DESC, 2 DESC

thanks

Claudio

>>>You have to group on all fields behind '*' and any of them cannot be Memo or Blob
>>>
>>
>>same error
>>
>>

>>SELECT  SUM(qty) as tot_qty, SUM(tot) as sumt, client, codesy, qty, unit, tot, comiss;
>>		FROM cur_products;
>>	GROUP BY codesy;
>>	ORDER BY sumt  desc, tot_qty, desc;
>>		INTO cursor cur_prod_tot
>>

>>
>>
>
>Once again, you have to group on all none-aggregate fields
>

>SELECT  SUM(qty) as tot_qty, SUM(tot) as sumt, client, codesy, unit, comiss;
>...
>GROUP BY client, codesy, unit, comiss ;
>
>* if grouping on codesy only
>
>SELECT  SUM(qty) as tot_qty, SUM(tot) as sumt, codesy ;
>...
>GROUP BY codesy ;
>
>