Maybe it ins't the best solution but you can use a group by (CustomerId), then you have to choose wich CustomerName is the choosen (min(CustomerName), max(CustomerName...). Sql: >select CustomerId, max(CustomerName) from Customer group by CustomerId.
Visit my blog at http://dotnetforeveryone.blogspot.com