多个SQL表的复合查询并且逗号拼接字段

表结构

需要从meeting和meeting_sign表得到下面这个表

SQL语句

我放的临时表

create table #tmp(
flag_userid nvarchar(max),
flag_no_userid nvarchar(max)
)
DECLARE @i int = 1
DECLARE @j int = 1
WHILE @i <= (select count(id)  from meeting)
begin
insert into #tmp(flag_userid,flag_no_userid)
select ( select stuff((
select ','+CONVERT(varchar(10),userid) from meeting_sign left join meeting m on  m.id=meetingid where flag='Y'and m.id=@i
for xml path('')),1,1,'') )as flag_userid,
( select stuff((
select ','+CONVERT(varchar(10),userid) from meeting_sign left join meeting m on  m.id=meetingid where flag='N'and m.id=@i
for xml path('')),1,1,'') )as flag_no_userid
SET @i = @i + 1
end
select * from #tmp  
drop table #tmp