create table A(ssid varchar(15),eeid varchar(15))
create table B(personid varchar(15),personname varchar(20))
insert into A values('001','003')
insert into A values('002','004')
insert into B values('001','张三')
insert into B values('002','李四')
insert into B values('003','王八')
insert into B values('004','陈九')
select b.personname,c.personname from A a inner join B b on a.ssid=b.personid
inner join B c on a.eeid=c.personid