Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kwikwisi
Constraint Violating Yak Guru
283 Posts |
 Posted - 2010-07-19 : 21:45:21
|
| How to get the comma seperated values from sub query ?select col1,col2,col3,.. from tableA join tableB on ...(@output1=get the comma seperated values(if more than 1 record) from tableC join tableA on ...)(@output2=get the comma seperated values(if more than 1 record) from tableC join tableB on ...)Result should be: col1,col2,col3,@output1='a,b,c',@output2='001,002,003' |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
|
|
|
|
|
Sub Query