Finding interconnected nodes of a graph using Oracle - SQL

Customer Master Account Local Account File
aaaa 10 100 D_10
bbbb 10 200 D_10
cccc 20 100 D_10
dddd 30 100 D_10
eeee 40 20 D_10
ffffff 50 30 D_10
500 50 D_10
------------------------------------------------------------------------------------------------------------
a1111 300 500 d_300
b1111 500 523 d_300
c0000 523 900 d_300
d0000 900 765 D_300
-------------------------------------------------------------------------------------------------------------

I have a problem to solve. I have a table that lists customer, Master
Account and Local Account for the customer. I need to group the related
accounts to a file - so that only one salesperson can handle the same.
I have to group all the related accounts together. Two accounts are
related if they are assigned to same customer somewhere. File name
could be anything - but the most important thing is related accounts
should be together.

However local account and master account do not have any tree relation
ship. Meaning a master can be a local and a local can be a master. So
it is not possible for me to use hierarchical query. Moreover I need
to group all the related accounts together

In the total data sets of local and master accounts - many connected
undirected graphs exists and I need to find
them all.

Can you suggest how can I accomplish this using Oracle - SQL. without
using recursive procedure.

.

Relevant Pages

  • Re: Customizing User Profiles in Control Panel
    ... I was trying to play with "control userpasswrds2" and after ... In any case, in the end I wound up with a ton of accounts, one of which (w/ ... this 2nd old desktop comp (as a Slave, the un-bootable, blown-MBR HD is ok). ... current Master HD. ...
    (microsoft.public.windowsxp.customize)
  • SQL Server Cache dependency not working
    ... all accounts. ... From Visual Studio, command line, aspnet_regsql, I enabled database cache ... Note my -S had to refer to a named instance ... To my SQLDataSource on my main master page (the datasource and master are ...
    (microsoft.public.vsnet.general)
  • Front Page cannot connect due to Kerberos failure
    ... I have a two domain environment with a domain MASTER and a subdomain ... User accounts are in MASTER, and a WIndows 2003 Server with IIS 6 ... Users can log onto the conolse of the server, ... However, when they attempt to connect to this IIS 6 server via Front Page, ...
    (microsoft.public.inetserver.iis.security)
  • Front Page cannot authenticate with IIS 6 on Windows 2003
    ... I have a two domain environment with a domain MASTER and a subdomain ... User accounts are in MASTER, and a WIndows 2003 Server with IIS 6 ... Users can log onto the conolse of the server, ... However, when they attempt to connect to this IIS 6 server via Front Page, ...
    (microsoft.public.win2000.security)
  • Re: ADPREP /forestprep fails
    ... > Schema Admins group (only keep two or three accounts). ... > the Schema Master DC with an Enterprise Admin/Schema Master Account. ...
    (microsoft.public.windows.server.migration)