This should help: http://tinyurl.com/hee59
> -----Original Message----- > From: loathe [mailto:[EMAIL PROTECTED] > Sent: Friday, September 01, 2006 3:46 PM > To: CF-Talk > Subject: Query Question > > I have an organization table. There is an org_id and a parent_org_id. > > I am trying to get all organizations from a certain point down. The > environment is DB/2. > > So far I'm doing: > > Select > org.org_id, > org.parent_org_id > From > organizations org > Left join > Organizations org2 > On > Org.org_id = org2.parentID > > Where org.org_id = #session.filter.org_id# > > > I know I have seen something similar to this before. It's no problem > going > down one level but there seems to be a need to do some sort of recursion > or > something in order to go lower than that. > > I'm beating myself over the head with this one, on a Friday afternoon, any > pointers would be much appreciated. > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:251806 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4