>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