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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-06-18 : 13:06:28
|
zeya writes "hi
create table tmp
(
code varchar(10),
caption varchar(10)
)
insert into tmp
select '1','cp1' union all
select '1','cp1a'union all
select '1','cp1f'union all
select '2','cp2'union all
select '3','cp3r'union all
select '3','cp3x'
select * from tmp:
code caption
1 "cp1"
1 "cp1a"
1 "cp1f"
2 "cp2"
3 "cp3r"
3 "cp3x"
output i want is
code caption
1 cp1 , cp1a, cp1f
2 cp2
3 cp3r ,cp3x
is there any single select query to do this?
-zeya" |
|
|
|
|
|
Complex Query