>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

>>Hi.. the error message says that I have an "invalid group by error".. My blind mind is not geting what should wrong down there.. Please, help me!!
>>
>>

>>SELECT  *, SUM(qty) as tot_qty, SUM(tot) as sumt;
>>		FROM cur_products;
>>	GROUP BY codesy ORDER BY sumt desc, tot_qty, desc;
>>		INTO cursor cur_prods_tot
>>

>>
>>TIA
>>
>>Claudio