Way to filter redundant records during a query?

[jwarmuth]

I have a software product database that I wish to extract only the list of software manufacturers. No problems there.

What I need to know is if I can filter redundant entries?

Example, if I query 'select Manufacturer from Software order by Manufacturer' it returns all the software records sorted by manufacturer. *joy*

Problem is, there are 10 records for 'Adobe', and I only want to see one (keep in mind, i'm only returning a single column of data). I just want to get a condensed view of the Manufacturers list, without an entry showing up once for every software title.

How can I do this?!


TIA.

Jeff W.
MCSE, CNE

 

[gmmastros]

select [red]Distinct[/red] Manufacturer from Software order by Manufacturer

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[jwarmuth]

*kiss*!



Jeff W.
MCSE, CNE