Jump to content

Archived

This topic is now archived and is closed to further replies.

ibanez270dx

Selecting Specific Data

Recommended Posts

Hi,
I have a product catalogue DB that includes fields for make, model, etc... There will be a lot of repetitiveness in the make field, for example, the make could be Ford and the model could be Ranger or F150 or whatever.

The thing is that there WILL be multiple makes, just there will be many repetitions. What I need to do is to pull out each make, but only once so I can have a bulleted list of the makes w/o repetition. How can I do this?

Thanks,
- Jeff

Share this post


Link to post
Share on other sites
SELECT DISTINCT make FROM products WHERE blah blah.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.