On Tue, Jan 18, 2005 at 02:51:01PM -0600, Bradley Miller wrote:
> select account_id from roll_account(1186) where hierarchy_type_id = 2
>
> The problem is I have data like this:
>
> account idname
>
> 1Company A
> 2Company B
> 3Company C
> 4Person 1 (in Company A
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:
selec
