SELECT membername, cname FROM members INNER JOIN membercat on members.mid = membercat.mid INNER JOIN categories on membercat.cid = categories.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 > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Community/message.cfm/messageid:243640 Subscription: http://www.houseoffusion.com/groups/CF-Community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.5
