ÇóÒ»sqlÓï¾ä - MS-SQL Server / »ù´¡Àà

±íA

UID name
1 Сºì
2 С¸Õ
3 СÃ÷
4 СÀ¼

±íB

ID groupname UID1 UID2
1 Î޵жþÈË×é 2 3
2 ÎÞÊÓ¶þÈË×é 1 4

ÎÒÒªµÃ±íBËùÓÐÊý¾Ý,µ«ÊÇuid1£¬uid2Òª¶ÔÓ¦±íaµÄÕæÃû,Èç:

groupname name1 name2
Î޵жþÈË×é С¸Õ СÃ÷
ÎÞÊÓ¶þÈË×é Сºì СÀ¼

---

²»Ê죬°ï¶¥

---

SQL code:
select B.groupname,A1.name,A2.name
from A A1,A A2,B
where A1.uid=B.uid1 and A2.uid2=B.uid2

---

SQL code:
--------------------SQL ServerÊý¾Ý¸ñʽ»¯¹¤¾ß-------------------
---------------------------------------------------------------
-- DESIGNER :happycell188(ϲϲ)
-- QQ :584738179
-- Development Tool :Microsoft Visual C++ 6.0 C Language
-- FUNCTION :CONVERT DATA TO T-SQL
---------------------------------------------------------------
-- Microsoft SQL Server 2005
-- Developer Edition on Microsoft Windows XP [°æ±¾ 5.1.2600]
---------------------------------------------------------------
---------------------------------------------------------------

use test
go
if object_id('test.dbo.a') is not null drop table a
-- ´´½¨Êý¾Ý±í
create table a
(
UID int,
name varchar(7)
)
go
--²åÈë²âÊÔÊý¾