Re: Ye old exploding parts problem....

From: Andy Hardy <aph_at_ahardy.demon.co.uk>
Date: 1997/02/05
Message-ID: <MODXXBAXSO+yEwh1@ahardy.demon.co.uk>#1/1

In article <01bc12fe$5adf2d60$90428ad0_at_pc060.dbsol.com>, RYoung <ryoung_at_summer.dbsol.com> writes
>
>-- I've been looking for an example I saw some time ago of the 'exploding
>parts' problem...how to get an organized 'dump' showing the heiarchy of
>parts for an item if all the parts for it and their part numbers are in the
>same table. It's a self join but I can't seem to remember how to put it
>together right......
>
>Anyone have it handy?
>
>Robert Young
>rcyoung_at_summer.dbsol.com
>"Standard disclaimer..."

Robert,

Isn't this an example of 'tree walking'? Have a look for the Oracle SQL 'CONNECT BY' statement.

Andy Hardy. PGP key available on request

---

Better living a beggar than dying an emperor. Received on Wed Feb 05 1997 - 00:00:00 CST