Being Friday I think I have to be having a brain drain.
I have a table that has the following structure AgentId, Name, ParentId This is basically creating a tree that would have something like this Root -ParentName1 --ChildName_Parent1 ---ChildName1 ---ChildName1_1 -ParentName2 --ChildName_Parent2 ---Childname2 ---ChildName2_1 ---ChildName2_2 Now the problem I am having is that I am going to need to get at ChildName2_2, get is parent and if the parent to that child has a parent. Can anyone see this in one SQL query? Andrew Scott Senior Coldfusion Developer Aegeon Pty. Ltd. <http://www.aegeon.com.au> www.aegeon.com.au Phone: +613 8676 4223 Mobile: 0404 998 273 --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~----------~----~----~----~------~----~------~--~---
