怎的串联查询结果

怎样串联查询结果？
SELECT [GroupID] FROM [sys_Group] where G_Delete=0 and G_ParentID=1 查询结果：
6
7
8

先要通过sql语句查询列出这样的结果：
dundiandanwei =6 or dundiandanwei =7 or dundiandanwei =8 

请问该怎么写，谢谢：)

------解决方案--------------------
try

SQL code

declare @s varchar(100)SELECT   @s=isnull(@s+' or ','')+' dundiandanwei = '+ltrim([GroupID]) FROM [sys_Group] where G_Delete=0 and G_ParentID=1select @s