INSERT INTO QuantityDiscount (ITEM_ID, Quantity1, Price1, Price1B) 
(
SELECT I.ID, SL.MasterPackQuantity,(I.Price), Round(((I.PriceB) * 0.92), 2)
FROM Item AS I
LEFT JOIN QuantityDiscount AS QD ON (I.QuantityDiscountID = QD.ID)
LEFT JOIN SupplierList AS SL ON (I.ID = SL.ItemID)
LEFT JOIN Supplier AS S ON (SL.SupplierID = S.ID)
WHERE ((((I.SubDescription1 = '1') OR (I.SubDescription1 = '4')) AND (SL.MasterPackQuantity is not null)))
)