I have a very simple query: SELECT tblcurrentCouncilMembers.Email, tblCouncilEmailGroup.GroupID FROM tblcurrentCouncilMembers INNER JOIN tblCouncilEmailGroup ON tblcurrentCouncilMembers.Member_ID = tblCouncilEmailGroup.MemberID WHERE tblCouncilEmailGroup.GroupID IN (17, 19, 21)
It works fine except that, as expected, if there is an email address in lets say group 17 and 19, it returns the same email address twice. So, can I filter the results in SQL so that if there is the same email address in more than one groupID, it only outputs that one? If not that is fine, I can do it with CF on the output. Thanks, -- Bruce Sorge "I'm a mawg: half man, half dog. I'm my own best friend!" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:2816 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6
