Return one one description per item

[udigold1]

Hi,
Let's say I've got a portfolio of stocks, that are managed in different banks.
Each Stock has a unique ID but can have a different description, depends on the bank, like the Following list:

ID	DESC
x1x1x1	Bla Ltd
x1x1x1	Bla Corp
x1x1x1	Bla Corp US
x3x3x3	Jcom
x3x3x3	Jcom US
yzyzyz	du.us
yzyzyz	du Corp
XvvYyy	milky.way
XvvYyy	milky Corp

I just want to get a table with one row per unique Stock, with description (I don't care which one) like the following:

ID	Desc
x1x1x1	Bla ltd
x3x3x3	Jcom
yzyzyz	du.us
XvvYvv	milky.way

how do I get it?
Thanks,

[CJ_London]

depends on whether you need to modify the data. Also need to decide whether your data structure is correct.

you might split the date into two tables

tblProducts
ProductID
GenericDesc

tblAliases
ID
ProductID
BankID
BankProductDesc


or if you don't need to modify the data, use a group by query

SELECT ID, First(Desc) as FirstDesc
FROM myTable
GROUP BY ID