-- 红球遗漏次数分析图select a.beforeterm,a.leaktimes,stuff((select ‘,‘+cast(ballnum as varchar(max)) from [Lottory].[dbo].[RedBall] b where a.leaktimes = b.leaktimes for xml path(‘‘)),1,1,‘‘) ballsfrom     (    select beforeterm, leaktimes    from [Lottory].[dbo].[RedBall]    group by beforeterm, leaktimes    ) a-- 篮球遗漏次数分析图select a.beforeterm,a.leaktimes,stuff((select ‘,‘+cast(ballnum as varchar(max)) from [Lottory].[dbo].[BlueBall] b where a.leaktimes = b.leaktimes for xml path(‘‘)),1,1,‘‘) ballsfrom     (    select beforeterm, leaktimes    from [Lottory].[dbo].[BlueBall]    group by beforeterm, leaktimes    ) a