SELECT t2.ProductID, 
t2.Name + '/'+ [Values1]+'(' + CAST(Part1ID AS varchar(5)) + ')'+
 '/'+ [Values2]+'(' + CAST(Part2ID AS varchar(5)) + ')'+
 '/'+ [Values3]+'(' + CAST(Part3ID AS varchar(5)) + ')' AS Name,
[Values1] AS Part1,
[Values2] AS Part2,
[Values3] AS Part3
FROM table2 t2
CROSS APPLY (SELECT m.PartID AS part1ID,m.Values AS Values1,n.PartID  AS Part2ID,n.Values AS Values2,o.PartID AS Part3ID,o.Values AS Values3
             FROM (SELECT ROW_NUMBER() OVER (ORDER BY [Values]) AS rn,PartID ,Values
                   FROM table1
                   WHERE PartID =1)m  
             CROSS JOIN  (SELECT ROW_NUMBER() OVER (ORDER BY [Values]) AS rn,PartID ,Values
                   FROM table1
                   WHERE PartID =2)n
             CROSS JOIN  (SELECT ROW_NUMBER() OVER (ORDER BY [Values]) AS rn,PartID ,Values
                   FROM table1
                   WHERE PartID =3)o    
               )t1