Here is an example of the request I was given before heading home, I am not sure how to even do this at this point. My sql is getting better the more I do it but this one has me scratching my head.
Here is an example of what I am looking for. The query Francisco helped me complete gives me all the information problem is how do I know which items out of the total per part is not a seperate piece part that was sold?
PN Description Finished Good Item
M98-027-0000 1. Bracket Assembly, H24-5 to T&E K24-026
M98-026-0000 1. Bracket, H24-5 to UPA, Sand CARC K24-026
M24-956-0000 1. Bracket, Adapter, ACH, 6-Hole, 10mm K24-026/K24-095/M24-700
M24-955-BLOX 1. Block, Guide, Right, H24 Mount K24-026
M24-954-BLOX 1. Block, Guide, Left, H24 Mount K24-026
M24-950-BLOX 1. Block, Travel Lock, H24-6 K24-026/K24-095/M38-210
M24-901-0000 1. Cradle Assy H24-5, Sand CARC K24-026/K24-095/M24-700
M24-515-BLOX 1. Train Lock Block, H24-3/-5/-6 (Rev A) K24-026
M24-296-SLOT 1. Pintle, H24, Slotted for use with Adapter, H24/UPA K24-026/K24-095/M38-210