I have the following SQL...
    SELECT 'TESTPRODUCT' AS Product_Code,Colours.Name FROM Product p
LEFT OUTER JOIN
    (
        SELECT col.Product_Id,colo.Name from ProductColour colo INNER JOIN
        Product__Colour col on colo.ProductColour_Id = col.ProductColour_Id
        group by col.Product_Id,colo.Name
    )   Colours
    ON p.Product_Id = Colours.Product_Id
  WHERE Product_Code = 'TESTPRODUCT'
My problem is that it returns...
    Product_Code    Name
    TESTPRODUCT     Black
    TESTPRODUCT     Blue
    TESTPRODUCT     Silver
What I need it to do is..
    Product_Code    Name1    Name2    Name3
    TESTPRODUCT     Black    Blue     Silver
Any ideas on how to achieve this?
 
    