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 domains.

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