Well the requirement is not important, so the basic question is how would you loop a table multiple times? Would you need to create temp tables?
For each Part
For First Part Where Part.PartMtlPart = Part.PartNum etc I don't think this would work, wouldn't you need to create a temp table to...