Returning a column into a comma list as part of another select stmt

or

select t1.col1,t1.col2,t2.colc
from table1 t1,table2 t2
where t1.col1=t2.colA

I think what he's trying to do is a little more complicated, my example is bad which I posted there.
In the case of my example you are complete right aiklamha.

grtz.

SOrry , left out the critical part of this
i need to put the inner select into the outer select as a column of comma seperate values

ie select from table

do inner select and get maybe five rows and convert into a comma list

then put this list into the first select as a another column

sorry about that didnt read what i posted

I think I understand what you mean now.
The scripts below should be able to do this.

You can use either one of them according to what are your further needs with this query.

select t1.col1, t1.col2, t2.csvCol
from table1 t1,
   (select colA|| ',' ||colB|| ',' ||colC as csvCol from table 2) t2
where t1.linkingKey = t2.linkingKey
 
---------------------------------------
 
select t1.col1, t1.col2, t2.colA||','||t2.colB||','||t2.colC as csvCol
from table1 t1, table2 t2
where t1.linkingKey = t2.linkingKey

Select allOpen in new window

erwin_huybregts, i think he's not only asking to append columns.. but rows also...

As jockmahon01 explained in his last comment I think it's clear he just wants to treat the select from the inner query as a column in the outer query. And the column needs to be a list of comma separated values using the columns from the inner query.

Ow my apologies misread something here:

do inner select and get maybe five rows and convert into a comma list

Then I think you can solve this with PL/SQL code but not in a simple query, as you need to use multiple rows.

can you provide some sample data and the results you expect from it?

thanks all