I've a situation where I'm retreiving the data in a subquery, the result for which can be multiple rows and columns.
And I want the result for this sub-query to appear in a single row for the parent query.
E.g. The Result from Subquery
No. - Name
1 - Google
2 - Yahoo
3 - MSN
The transformation for the parent query
List of Names
1 - Google, 2 - Yahoo, 3 - MSN
Can anyone help me on achieving this?