Concatenate detail value in one column

[krishnarao]

i'm using Master and Detail table. Master table i have TaskId, ResId where ResId is mapped to Detail table which contains resource working on the task. i want to generate a query where for each task i want to display resource id in single column like below.

Task Id Resource Id
1 222,233,244,255

Do i need to use recursive query or any other method to get results like above.

 

[MStef]

How is your tables looks like??