you must group by the three fields (Field1,Field2, Field3)

regards too

>
> Hello,
>
> I have following select statement, which reports me an error (error
> code -104, invalid expression in the select list):
>
> select Field1,Field2, Field3,
> SUM(Field4) as SField4,
> SUM(Field5) as SField5,
> SUM(Field6) as SField6
> from TABLE
> group by Field1
> order by Field1
>
>
> I want to get a sum of fields 4,5,6 for each of Field1.
>
> What am I missing here ?
>
>
>
> Regards,
> Primoz
>
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>