这个查询该怎么做

[cloudgamer]

例如有如下记录
id1 id2
1 2
1 3
2 4
5 4

我想找1相关的数据
根据id1能得到 2 3
根据2 得到 4
根据4 得到 5
最后得到id为
2 3 4 5
的关联记录
这个怎么查询出来呢

[cloudgamer]

2 3 4 4
？
不是我想要的结果啊

[cloudgamer]

其实就是找出所有有关联的数据

[抓不住老鼠的猫-总是眼睁睁看它逃跑]

帮顶了..

[lxy_swufe]

关注！！！！

[jaydom]

没怎么看明白，感觉不难，建议楼主重新描述一下，下午有事只能帮顶啦

[ling201003]

什么意思呢。。。关注

[ChinaJiaBing]

--try


if object_id('tb') is not null
   drop table tb 
if object_id('pro_c')is not null
   drop procedure pro_c
go
create table tb (id1 int,id2 int)
insert into tb select 1,2
     union all select 1,3
     union all select 2,4
     union all select 5,4
go
create procedure pro_c 
@id nvarchar(10)
as
begin
declare @str nvarchar(10)
set @str=''
select @str=@str+' '+ ltrim(id2) from tb where charindex(ltrim(id1),@id)>0
select @str
end
go
exec pro_c 125


/*


 2 3 4 4

(1 行受影响


*/

[cloudgamer]

[cloudgamer]

[ask_chang]

写明白点，一个表关联自己吗？

[cloudgamer]

id1 id2是另外一个表的id
这个表是记录他们的关联关系

[ShenLiang2025]

--1)表和数据

CREATE TABLE #for_csdn
(id1 int,
id2 int)
INSERT INTO #for_csdn VALUES(1,2)
INSERT INTO #for_csdn VALUES(1,3)
INSERT INTO #for_csdn VALUES(2,4)
INSERT INTO #for_csdn VALUES(5,4)

--2)代码段

DECLARE @str varchar(MAX)
SET @str = ''
SELECT @str = ISNULL(@str + ' ','')+CAST(IDEN AS varchar(30))FROM
(
SELECT IDEN = id2 FROM #for_csdn B
INNER JOIN 
(
SELECT id1 FROM #for_csdn
GROUP BY id1
HAVING COUNT(1) > 1)A
ON A.id1 = B.id1

UNION 

SELECT IDEN = id1 FROM #for_csdn C
INNER JOIN (
SELECT id2 FROM #for_csdn
GROUP BY id2
HAVING COUNT(1) > 1)D
ON C.id2 = D.id2

UNION 

SELECT IDEN = id2 FROM #for_csdn
GROUP BY id2
HAVING COUNT(1) > 1)F

SELECT iden = @str

--3)结果

iden
--------------------------------------
 2 3 4 5

(1 row(s) affected)

[cloudgamer]

ls的有问题呢

INSERT INTO #for_csdn VALUES(1,2)
INSERT INTO #for_csdn VALUES(1,3)
INSERT INTO #for_csdn VALUES(2,4)
INSERT INTO #for_csdn VALUES(5,4)
INSERT INTO #for_csdn VALUES(6,7)
INSERT INTO #for_csdn VALUES(7,8)
INSERT INTO #for_csdn VALUES(9,10)

这样的话应该是
12345
678
9 10
这样分才对
但ls都混在一起了

[small_agile]

declare @t table (id int,id2 int)
insert @t 
select 1,2 union all
select 1,3 union all
select 2,4 union all
select 5,4
select * from @t

declare @var varchar(20)
select @var=isnull(@var+',','')+ cast(id2 as varchar(20)) from @t

select c= @var