Re: Ye old exploding parts problem....

From: Francisco C P de Almeida <piragibe_at_esquadro.com.br>
Date: 1997/02/06
Message-ID: <01bc13fe$383130a0$6b55ffc8@chico>#1/1

In fact, it's not a self join; rather, it's a tree walking query. 'might look like this one:

select ....
from parts
connect by prior part_id = parent_part_id start with part_id = <part_id of master product>

By the way, if a part may be a component of several other parts, you should put the parts tree in a different table and modify the above query accordingly.

-- 
Francisco C P de Almeida, consultor
Tel: 55-21-5125064
piragibe_at_esquadro.com.br

RYoung <ryoung_at_summer.dbsol.com> escreveu no artigo
<01bc12fe$5adf2d60$90428ad0_at_pc060.dbsol.com>...


> 

> -- 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..."

>

Received on Thu Feb 06 1997 - 00:00:00 CST