表的自连接一例

create table t(team varchar(1))

 

insert into t values('a')

insert into t values('b')

insert into t values('c')

insert into t values('d')

go

 

select * from t

select m.team , n.team from t m, t n where m.team < n.team order by m.team

 ------------------

a

b

c

d

----》

a b

a c

a d

b c

b d

c d