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 |
|
KenA
Starting Member
28 Posts |
 Posted - 2006-03-05 : 00:42:20
|
| Supose I have the following select:Select Name, Age, (select TelNums from Telephone)From PersonThe problem is that (select TelNums from Telephone) can return more than 1 record:tel1tel2...I was wondering how I can make a select to return the tel numbers like: 'tel1,tel2,tel2'»»» Ken.A |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
|
|
KenA
Starting Member
28 Posts |
Posted - 2006-03-05 : 07:59:56
|
| Thanks ... that anwered my question. But now I´m in doubt whether doing it or not.Since my query doesn´t return large amounts of data, I believe it´s ok to use it.»»» Ken.A |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-03-06 : 00:28:18
|
| The referred link is the way to go if you want to do this in SQL queryMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Add a column based on a select query