Hi All !!! I have the following Orders Table. The ORDER_ID is repeated on multiple lines depending on the amount of colours that were ordered:
ORDER_ID; PRODUCT_COLOR
123456 Blue
123456 Black
123456 Red
123457 Blue
123457 Red
123458 black
I need to have the order ID outputted on a single line, with the colors combined into one field, so the output is as follows:
123456 'Blue + Black + Red'
123457 'Blue + Red'
123458 'Black'
I'm not quite sure how to do this, Any ideas? thanKS!
SELECT ORDER_ID, PRODUCT_COLOR FROM ORDERS
Simple Problem!
Posted - 09/24/2012 : 14:52:45
