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