I have the following table Name Grandparent Parent Child ======================================== Fishing 100 0 0 Reels 100 1 0 Baitcast 100 1 1 Spinning 100 1 2 Hunting 200 0 0 Archery 200 1 0 Bows 200 1 1
I am going nuts trying to write a query that will give the final result of: Fishing/Reels/Baitcast Fishing/Reels/Spinning Hunting/Archery/Bows ect... Is this possible to do in a query? Any help from you master minds would be helpful... My request was to not have queries within a loop so I am not sure it is doable .. ANY suggestions welcome! Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector v2.0 - Commerce Builder ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
