MVSFORUMS.com

[sonika2008]

I have a SQL statement that fetches ID, SR.No, place information.
like this:-

ID Sr. No Place
123 x abc
x def

I want that if the Sr.No is same , than palce information display in one row
like this:-

ID Sr. No Place
123 x abc def

Is there any way to concatenate the two lines become one?

[kolusu]

sonika2008,

show us your sql as to how you are getting the rows in that fashion

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

[viswanathan]

Hi Sonika,


Please try this


select a.id, a.srno,a.place,b.fieldname from table1 a, table2 b
where a.srno = b.srno

If my understanding is wrong..please provide us more info in this regard.

-Vishwa

[sriramla]

Viswanathan, your query would result in duplicates. If there are 2 rows with same id, the poster want to combine them into a single row. But the join you have would give 4 rows (2 * 2).

[A_programmer]

What about if there are multiple rows with the same Sr. No. ?
How can you dynamically add columns ????
_________________
Its not necessary to change. Survival is not mandatory.