If there's a group that's jewish and college, I just need a single record returned.
================= Then removed type from the select list, group by everything else with an "or" equivalent in your where clause and add the "having count(*) > 1" to the end. That will only return groups which returned a record for both the Jewish and College type. Alternatively, inner joining to the type table twice, once for each type you want will work as well but might not perform as well. ~Brad ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300358 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
