select * from members m inner join membercat mc on mc.mid = m.mid inner join category c on c.cid = membercat.cid
untested 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 > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Community/message.cfm/messageid:243643 Subscription: http://www.houseoffusion.com/groups/CF-Community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.5
