help with MySQL SELECT statement

2002-07-10 Thread Kirk Babb
Easy question I hope, relatively new user ( 6 months) here wanting to know how to fashion a MySQL select statement based on the following: there is a list of managers and their email addresses. This list changes all the time as we add and subtract different companies from the db. I would like

Re: help with MySQL SELECT statement

2002-07-10 Thread Kirk Babb
wait, how will the MySQL SELECT DISTINCT pick only one between these two addresses (as an example): [EMAIL PROTECTED] [EMAIL PROTECTED] I only need one email address each for alltel.com, one for ualr.edu, one for target.com, etc. when there might be 50 email addresses from each of those