-
本版专家分：0结帖率 100% -
表A
ID Name
1 张三
2 李四
3 王二
表B
ID Person1ID,Person2ID,Pserson3ID
1 1 2 2
怎样能得到这样的结果
ID Pserson1Name,Person2Name,Person3Name
1 张三 李四 王二
问题点数：25分
-
本版专家分：4660 -
select B.ID,A1.Name,A2.Name,A3.Name
from B
JOIN A A1 ON B.Person1ID=A1.ID
JOIN A A2 ON B.Person2ID=A2.ID
JOIN A A3 ON B.Person3ID=A3.ID
-
本版专家分：0
-
表B应该是
ID Person1ID,Person2ID,Pserson3ID
1 1 2 3
-
本版专家分：36544 -
Select a.ID,b.Name as Pserson1Name,c.Name as Pserson2Name
,d.Name as Pserson3Name
from 表B as a inner join 表A as b on b.ID=a.Person1ID
inner join 表A as c on c.ID=a.Person2ID
inner join 表A as d on d.ID=a.Person3ID
-
本版专家分：6196 -
select b.ID ,Pserson1Name=case when Person1ID=1 then '张三' end,
Person2Name=case when Person2ID=2 then '李四' end,
Person3Name=case when Person3ID=2 then '王二' end
from 表B b join 表A a on a.id=b.id
-
本版专家分：6196
-
select b.ID ,Pserson1Name=case when Person1ID=1 then '张三' end,
Person2Name=case when Person2ID=2 then '李四' end,
Person3Name=case when Person3ID=3 then '王二' end
from 表B b join 表A a on a.id=b.id
-
本版专家分：27184
-
- 黄花 2004年11月 MS-SQL Server大版内专家分月排行榜第二
-
-
Select a.ID,
Pserson1Name=(select top 1 name from 表A where id=b.Person1ID),
Pserson2Name=(select top 1 name from 表A where id=b.Person2ID),
Pserson3Name=(select top 1 name from 表A where id=b.Person3ID)
from 表B b
