Doable? Implementation depends on your database and structure. --- Billy Cravens
-----Original Message----- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 24, 2002 2:14 PM To: CF-Talk Subject: OT: SQL Booger of a query 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 ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm 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
