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 >>>>