>>>Thanks all! :o)
>>>
>>Looks like Cetin's SQL is the simplest.
>>
>>It's a bit unclear what do you mean by "every distinct or unique aid record". Is aID the PK for the table?
>
>Not exaclty.
>
>If you have records like:
>

>
>AID            AAGcy
>---------------------
>1             AAAA
>1             BBBB
>1             CCCC
>
>

>With Cetin's solution you will get:
>

>AID            AAGcy     adescriptn
>------------------------------------
>1             CCCC       bla bla
>

>With mine:
>

>
>AID            AAGcy   adescriptn
>----------------------------------
>1             AAAA      bla bla
>1             BBBB      bla bla
>1             CCCC      bla bla
>

>
>So it all depends of what Tracy needs :-)

Right, that's why we need some clarification.