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:
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'
I'm not quite sure how to do this, Any ideas? thanKS!
SELECT ORDER_ID, PRODUCT_COLOR FROM ORDERS