>>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 :-)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
