> Category Path: Sports -> Hockey -> Teams -> Buffalo Sabres > > You want to find anything that is a member of the hockey > category and any sub category within.
Really busy but recommend googling (and the HoF archives) on Joe Celko , he seems to be the master of the parent-child tree in SQL :) (His book SQL for Smarties is meant to be good too!). Looking for nested set stuff I think... Alternatively if you are on Oracle a very nice cheat is 'CONNECT BY ... PRIOR' and 'SYS_CONNECT_BY_PATH'. Sorry can't be of any more help at the moment. -- dc ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:206056 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54