declare @t table(id varchar(10),objname varchar(10), Pname varchar(10))
insert into @t
select '001','A','002' union
select '002','B','003' union
select '003','C','001'
select * from @t
--SQL
select t1.id,t1.objname,t2.objname
from @t t1
left join @t t2 on t2.id=t1.pname
--------------------------------
(3 个资料列受到影响)
id objnamePname
---------- ---------- ----------
001A002
002B003
003C001
(3 个资料列受到影响)
id objnameobjname
---------- ---------- ----------
001AB
002BC
003CA
(3 个资料列受到影响) |