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?