Thread: Recursive query to be used in another result ?

I need some help on the following problem.  I have an account info
table that has a hierarchy of accounts.  The grouping goes from end
user to organization to reseller.  I have a PL/SQL function written
that gives me the tree, so I just whittle it down by selecting the one
id for a reseller:

select account_id from roll_account(1186) where hierarchy_type_id = 2

The problem is I want to have that account_id number (1186) to be
selected from my main query.  (IE:  select account_id from
account_info)

Can anyone offer some solutions to this problem?


Bradley Miller
NUVIO CORPORATION
Phone: 816-444-4422 ext. 6757
Fax: 913-498-1810
http://www.nuvio.com
bmiller@nuvio.com