[SQL ] 子查詢併成一欄
database:MS SQL Server
請問我有兩個Table A,B,要怎麼下才能變成Table C呢??
換個說法就是,要怎樣把Table B的column串成一行??
Table A
--------------
ID name
1 Mark
2 Mary
3 Leo
Table B
--------------
ID city
1 Taipei
1 Tainan
2 Taipei
3 ChangHua
3 Kaohsiung
Table C
--------------
ID name city
1 Mark Taipei,Tainan
2 Mary Taipei
3 Leo ChangHua,Kaohsiung
謝謝:)
--
請勿拍打、餵食!
http://www.wretch.cc/album/etchen
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 218.211.33.46
推
03/31 16:01, , 1F
03/31 16:01, 1F
→
03/31 16:06, , 2F
03/31 16:06, 2F
→
03/31 16:21, , 3F
03/31 16:21, 3F
推
04/01 14:22, , 4F
04/01 14:22, 4F
→
04/12 13:58, , 5F
04/12 13:58, 5F
討論串 (同標題文章)
以下文章回應了本文:
完整討論串 (本文為第 1 之 6 篇):