It will repeat the members for each category...that's just the nature of the inner join.
On 10/5/07, Erika L. Walker <[EMAIL PROTECTED]> wrote: > > awesome awesome, thank you ... you guys are the bestest. > > next question. Members show up multiple times in the membercat table > because > they can belong to multiple categories.... > > SELECT mcompany, bizcategory > FROM members > INNER JOIN memberscat on members.memberid = memberscat.memberid > INNER JOIN bizcat on memberscat.bizid = bizcat.bizid > > Worked first time out of the box .... but, what happens with multiple > categories ... > > What I am trying to do is get the data from one datasource, dump it into > another, but all in one table, which means a pipe delimited list of the > categories all in one field. > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Community/message.cfm/messageid:243649 Subscription: http://www.houseoffusion.com/groups/CF-Community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5
