I have an sql code that is retreiving a row with more than one line, Is there a way to make it combine those two lines into one line.
select revertrsn from LN08PENm where aano in(754,870,1136,1138,1139,1140)
the data coming in the row that I am retreiving is like this:
As per Mohammad Sulaiman's approval
by mail date 07/04/2009
And I want it to be in one line like this:
As per Mohammad Sulaiman's approval by mail date 07/04/2009