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