BOM Select statement

2004-03-01 Thread Wesley Baker
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

table restructure

2003-12-02 Thread Wesley Baker
ing like 1.4gb and RSS shows like 750 Mb for the mysql process. Wesley Baker