jhinch (4/23/2014)
I apologize for not using the proper forum etiquette. This was my first post ever, and I overlooked the etiquette section before posting. I will follow the proper procedure on future posts.The reason I want to join differing values is because the p.item is a required material in the BOM for the c.item
I would like to order both statements by their due date so I can see if the raw material (p.item) quantity will be sufficient to produce the finished good (c.item). I just need a way to link the two values together based on the respective BOM requirement.
Why not use the BOM tables as your link between raw material and finished goods?
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden