By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
PART | SUBPART | QUANTITY | LINE_NUMBER |
---|---|---|---|
PRODUCT1 | PART1 | 1 | 1 |
PRODUCT1 | PART2 | 1 | 2 |
PRODUCT1 | SUBASSEMBLY1 | 2 | 3 |
PRODUCT1 | PRODUCT2 | 1 | 4 |
SUBASSEMBLY1 | PART3 | 4 | 1 |
SUBASSEMBLY1 | PART4 | 4 | 2 |
PRODUCT2 | PART3 | 2 | 2 |
PRODUCT9 | PART6 | 5 | 1 |
PART |
---|
SUBASSEMBLY1 |
PART | SUBPART | QTY |
---|---|---|
PRODUCT1 | PART3 | 8 |
PRODUCT1 | PART4 | 8 |
PRODUCT1 | SUBASSEMBLY1 | 2 |