I am building a baq that looks at the part mtl table and pulls out the parent part and mtl part. I then build 5 sub-queries linking mtl part to part num of the next query down. This gives me a blow out of a bom for each parent part.
What I want to do next is link all the subqueries together using a Union or Union all statement like the one below:
The idea is to have all mtl parts listed next to their primary parent part. However, as I click to analyze the Epicor Crashes. Has anyone else done something similar or have an idea on how to get this working?