[thelist] duplicates

[Carolyn Jewel]

Is there away in a query to add to the select statement that if there is
more then one record of the same id not to pull it.

SELECT DISTINCT 

Carolyn J.


****This electronic mail message, and any attachments transmitted with it, contains confidential information, intended only for the named addressee(s). If you are not the intended recipient, or a person responsible for delivering this e-mail to the intended recipient, you are hereby notified that the use, distribution, copying, or disclosure of this communication is strictly prohibited. If you have received this e-mail in error, please immediately notify the sender by reply e-mail, and delete all copies of this communication from your computer and network. Thank you.*****