Falko Rotter wrote:
>
> Hi,
>
> > c1 c2 c3 c4 c5
> > A1-X21 000123456 100 EA part_A
> > A1-X22 000123456 100 EA part_A
> > B1-Z12 000123456 2 EA part_A
> > C1-X13 000123456 10 EA part_A
> > B1-Z11 000654321 20 EA part_B
> >
> > and I want my select result as
> > A1-X21 000123456 100 EA part_A
> > B1-Z11 000654321 20 EA part_B
> >
Thanks Falko. excuse my naive respond. I tried to leatn such kind of
query.
>
> please explain me how and why is this your result!
I do not know why. However, That is the result I intend to get, and I
want to know How query will give me that.
> - do you want to group only by field c2 ?
C2 is my primary gourp. Could I have another group within another query
which has a primary group by ?
> - how should aggregate the other fields in the group ?
>
> Regards,
> Falko Rotter
>
> _________________________________________
>
> - Software Developer -
>
> Rotter & Kalweit Softwaredesign GbR
> Friemarer Straße 38
>
> 99867 Gotha
> GERMANY
>
> mail: news_at_falko-rotter.de
Received on Mon Aug 20 2001 - 21:44:11 CDT
