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:243644 Subscription: http://www.houseoffusion.com/groups/CF-Community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.5
