I have a field ...using a where statement to get data. example. where o1.test in ('10344')
if =10344 then bring in 10122 and 10133(these are all in the same field...connected to the same order.
I want them to put in new column ...ex. order col 2. col 3
10344. 10122. 10133