You have to group on all fields behind '*' and any of them cannot be Memo or Blob
>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
--sb--