>hi all,
>i have the code below that i think should work but it isn't. there is a problem with the sum command but i just cannot see it. i know that its bound to be something easy but any help appreciated at this late hour
>
>SELECT *, sum(KBI_qty) as gtotal ;
> FROM KBI ;
> GROUP BY KBI_stkref ;
> ORDER BY KBI_stkref ;
> INTO temp8
>
>~M
You cannot have '*' in field list, but you could
SELECT KBI_stkref, sum(KBI_qty) as gtotal ;
FROM KBI ;
GROUP BY 1 ;
ORDER BY KBI_stkref ;
INTO temp8
If you want more fields then they should be 'enclosed' by aggregate function(s).
Edward Pikman
Independent Consultant