62,041
社区成员
发帖
与我相关
我的任务
分享
declare @a varchar(max)
declare @v varchar(50)
declare cur cursor
read_only
for select pid from 主表
declare @name varchar(40)
open cur
fetch next from cur into @name
while (@@fetch_status =0)
begin
set @a='';
select @a=@a+color+',' from 从表 where pid=@name
--print @name+' '
--print @v+' '
--print @a
select [pid],[name],@a from 主表 where pid=@name
fetch next from cur into @name
end
close cur
deallocate cur
go