Try putting codesy, instead of the *
Luis
>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
I never forget a face, but in your case I will make an exception :-)