CREATE TABLE BOM(PID INT,ID INT,Qty INT) INSERT INTO BOM SELECT 801,101,1 INSERT INTO BOM SELECT 801,102,2 INSERT INTO BOM SELECT 801,103,3 INSERT INTO BOM SELECT 801,601,1 INSERT INTO BOM SELECT 601,201, 1INSERT INTO BOM SELECT 601,105,2INSERT INTO BOM ... |