Show only once

[muppetmad]

I have two tables, one for categories and one for records. I have sorted out the active records. But I only want to see each category once. Right now I see the category for each active records.

What I am looking for is a list of categories that have active records in them.

 

[muppetmad]

I figured it out. Thanks anyway. This is a great site.