Eliminating duplicate results

[bbarby]

Hey all,

Query that's returning 62 rows. That's OK, I need them all. But those results are broken down in to sub catagories. I need one, and only one, instance of each sub category, but I'm getting multiples.
item: Subcat:
1 a
2 a
3 b
4 c
5 c
6... c....

So I get 2a's, 1b, 3c's etc.... How can I get the a return of only one of each, with no duplicates? Or eliminate the duplicates? I only need to know /what/ sub-cats are used, not how many of them.

Thanks in a advance,

Benjamin

[tha_mink]

SELECT distinct [column name] from [tablename];

[bbarby]

Hey Tha... welcome aboard!

Thanks for the suggestion, but it didn't seem to work.

It did have an effect, but it's still giving me multiples of the sub-cats.

Benjamin

[bbarby]

DOH!

I hate when that happens!

You're right. It worked. :-)

I just didn't look at my results close enough.

Thanks for the hand.

Benjamin