from the "nothin fancy" collection: select * from membercat MC, category C, members M where M.mid = MC.mid and C.cid = MC.cid
On 10/5/07, Erika L. Walker <[EMAIL PROTECTED]> wrote: > > been too long, hope someone can rattle this off without me trying and > failing for hours > > 3 tables. > > Members, categories, ID table which joins the two > > need to select all the members and their corresponding categories. > > members: mid, membername > category: cid, cname > membercat: mid, cid > > what does my sql look like?? just a point in the right direction please > ... > > Thanks, > Erika > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:243641 Subscription: http://www.houseoffusion.com/groups/CF-Community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.5
