Thanks... At some point, the client has *got* to stop adding features! I've pretty much figured a way to PREVENT sub branches from having their own subs, so at least that part of the problem is licked!
Les :> select B1.Branch_Name, B2.Branch_Name :> FROM :> Branches B1 :> LEFT JOIN :> Branches B2 :> ON B1.branch_id = B2.sub_branch :> :> Might have to play with the join a little bit, but that's the :> basic concept. :> :> This only does branches and sub-branches. It gets significantly more :> complex when your sub branches have their own subs, and sub's subs have :> subs, etc. At that point, depending on the size of the data, it's often :> much easier to just load it all into a structure and process in CF (faster :> too).http://www.fusionauthority.com/ads.cfm ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
