>MyTable:
>CLIENT RECORD
>001 AAAAAA
>001 BBBBBB
>001 CCCCCC
>002 AAAAAA
>002 BBBBBB
>002 CCCCCC
>
>If I run the following command:
>SELECT * FROM MyTable GROUP BY client
>
>The result should be:
>001 CCCCCC
>002 CCCCCC
>
>The problem is that I am getting this result:
>001 AAAAAA
>002 AAAAAA
>
>Can someone in here give me some hints why this is happening? Thank you in advance. Any comments will be welcome.

---

Morys,
Is physical order of records in myTable just like you wrote or is it an ordered display ? If that's the physical order then I'm stumped too.
Cetin