Hi Paul,
What fields are you trying to search on?
- Matt Small
-----Original Message-----
From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 24, 2002 3: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
______________________________________________________________________
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.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
