Hello
was wondering is there a way to multiple values of a order into one row
Code:
currently if i do select * from order_code_placed, i get the following
orderid code ord_seq
345901 33 1
345901 75 2
345901 88 3
345901 101 4
345901 114 5
345901 127 6
345901 33 7
345901 75 8
345901 33 9
345901 75 10
345901 33 11
345901 75 12
345902 16 1
345902 45 2
345902 74 3
345902 103 4
345902 132 5
345902 77 6
345902 44 7
345902 52 8
345902 32 9
but would like to display like this,is this possible.
orderid code
345901 33,75,88,101,114,127,33,75,33,75,33,75
345902 16,45,74,103,132,77 ,44 ,52 ,32
any help is much appreciated.thanks much