I have a file called STRUCTUR which is typical of any Bill-Of-Materials
in an MRP system. The format is similar to this:
STRUCTUR.ITEM, STRUCTUR.QTY, STRUCTUR.PARENT_ITEM
You define multi-level material lists for items and for components of
those items ... Here is an example
ITEM; QTY; PARENT_ITEM
harddrive, 2, mynewpc
modem, 1, mynewpc
case, 1, mynewpc
monitor, 1, mynewpc
screws, 10, case
sheetmetal, 4, case
powersupply, 1, case
capacitor, 10, powersupply
transformer, 1, powersupply
screws, 5, powersupply
What I want is to know how to build a SELECT statement which will
return all components of mynewpc and navigate down the bill-of-materials
and also return all the components for the case, the powersupply and
even the parts on the powersupply.
I'm trying to write an indented bill-of-materials with CrystalReports
and the SQL is stumping me.
Thanks
Wesley Baker
