• Is this a bill of materials ?

    Try this...

    http://sqlblog.com/blogs/john_paul_cook/archive/2009/10/11/bill-of-materials-where-used-query.aspx



    Clear Sky SQL
    My Blog[/url]