DECLARE @name varchar(256)
set @name=''
select @name=@name+t_2.name+';',t_1.*
from t_1,t_2
Where t_2.fid = t_1.fid
set @name=''
select @name=@name+t_2.name+';',t_1.*
from t_1,t_2
Where t_2.fid = t_1.fid
向变量赋值的 SELECT 语句不能与数据检索操作结合使用。
set @name=''
select t_1.*,'',@name+t_2.name+';'
from t_1,t_2
Where t_2.fid = t_1.fid
id, name
------------
2 a
2 b
2 c
3 d
3 e
4 f我想选出id, name
------------
2 a,b,c
3 d,e,f