>I'm a little unsure of what your query is expected to return. If a >group can have multiple types, then I assume that there is a one-to-many >relationship between groups and types, where a single group record has >one or more type records.
Correct. > >You are returning type in your query, so a group with 5 type records, >would be duplicated 5 times in the result set-- once for each type. Do >you want this, or do you want a single record for the group no matter >how many types they match? If there's a group that's jewish and college, I just need a single record returned. Thanks, Will ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:300357 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
