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
<x-tad-bigger>NUVIO CORPORATION</x-tad-bigger><x-tad-bigger>
Phone: 816-444-4422 ext. 6757
Fax: 913-498-1810
</x-tad-bigger><x-tad-bigger>http://www.nuvio.com</x-tad-bigger><x-tad-bigger>
</x-tad-bigger><x-tad-bigger>[EMAIL PROTECTED]</x-tad-bigger>
