表结构
create table tabTest
(
Id varchar(10),
name varchar(20),
parentId varchar(10)
)
go
数据情况:
自关联语句:
select a.Id,a.name ,b.name as leader from tabTest a,
(select id,name,parentid from tabTest )b
where a.parentId =b.Id
查询结果:
左关联语句
select a.Id,a.name ,b.name as leader from tabTest a left join
(select id,name,parentid from tabTest )b
on a.parentId =b.Id
查询情况: