troubleshooting Question

bom where used

Avatar of Fairfield
FairfieldFlag for United States of America asked on
Microsoft SQL Server 2008
10 Comments1 Solution748 ViewsLast Modified:
I have two tables, one that consists of a parts list and the other that contains bom information with parent and child.  In need to take the list of parts and find all of the parent part numbers where the parts list exist. The parts from the parts list table could be in parent part numbers or could be in higher assemblIes.   How would I do this?

Parts List Table
------------------
PartID


BOM Table
----------      ------------
ParentID      ChildPartID
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 10 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 10 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros