Multiple Left Joins for Combinations, Sql Server

Language: Layout:

CREATE TABLE #ProductRecipe (ProductRecipeID INT, Component1 INT, Component2 INT, Component3 INT, Component4 INT, Component5 INT);
CREATE TABLE #ComponentPricing (RowID INT, PricingID INT, ProductID INT, ProductDescription VARCHAR(50), Cost DECIMAL(18,6));

INSERT INTO #ProductRecipe (ProductRecipeID, Component1, Component2) VALUES (21, 130, 468);
INSERT INTO #ComponentPricing (RowID, PricingID, ProductID, ProductDescription, Cost)
VALUES (1, 314023, 130, 'ULS2', 1.783800)
 , (2, 313616, 130, 'ULS2', 1.783800)
 , (3, 313071, 130, 'ULS2', 1.794000)
 , (4, 312865, 130, 'ULS2', 1.789500)
 , (5, 316323, 468, 'B100', 1.550500);

SELECT p.ProductRecipeID, c1.PricingID AS Component1, c2.PricingID AS Component2, 
       c3.PricingID AS Component3, c4.PricingID AS Component4, c5.PricingID AS Component5
FROM #ProductRecipe p
LEFT JOIN #ComponentPricing c1
    ON p.Component1 = c1.ProductID   
LEFT JOIN #ComponentPricing c2
  ON p.Component2 = c2.ProductID
LEFT JOIN #ComponentPricing c3
  ON p.Component3 = c3.ProductID
LEFT JOIN #ComponentPricing c4
  ON p.Component4 = c4.ProductID
LEFT JOIN #ComponentPricing c5
  ON p.Component4 = c5.ProductID

View schema
Execution time: 0,03 sec, rows selected: 4, rows affected: 6, absolute service time: 0,25 sec, absolute service time: 0,26 sec