change the INNER JOIN memberscat to RIGHT OUTER JOIN memberscat 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. > > >
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finder&productID=1522&loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Community/message.cfm/messageid:243646 Subscription: http://www.houseoffusion.com/groups/CF-Community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5
