Oracle Version 10g
I have a table (BOM) with 3 fields (ITEM, COMP_ITEM & COMP_QTY)
ITEM is the parent of COMP_ITEM and COMP_QTY is the quantity of COMP_ITEM's
I want to find all the top-level ITEM's of a given part (where used) and the cumulative quantities (how many X's are in a A ,D and K)
I have looked around many forums but still haven't come up with a working answer. I know I can't use the WITH command as in.... 'WITH bob (a,b,c) as' because my database is not up to the right version. I need to go at most about 10 levels. I have tried nested queries with joins but I just get lost in the syntax.
Could someone please point me in the right direction