By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,348 Members | 1,397 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,348 IT Pros & Developers. It's quick & easy.

Stripping multiple identical entries to display only one.

P: 1
I am working on building a dynamic menu that searches the database for the manufacturer ID to get the product catagories for the submenu. The problem that I am having right now is that when searching the Products table, there are multiple entries from the same manufacturer thus showing multiple instances of the same manufacturer in the menu. What I am trying to do is search the Products database table and get all of the Manufacturer IDs then pull out just one of each instead of ALL of them since there are multiples of each. Any and all help is GREATLY appreciated.
Apr 24 '07 #1
Share this Question
Share on Google+
2 Replies

code green
Expert 100+
P: 1,726
Select Distinct
Apr 25 '07 #2

Expert 2.5K+
P: 3,235
Post your SQL query?
Apr 25 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.