Under the object explorer in SQL it's showing me about 5-10 columns but they all say "non-unique, non-clustered". When I go into design view of the table > indexes it shows me about 8-10 fields ...

Do you want to find out how to avoid duplicates in the results of a SQL SELECT query? This article will show you how. To avoid duplicate results: Simply use the DISTINCT clause and between the SELECT ...