sql:


select * from zhubiaofushu where id in 
(select fid from zhubiao)

select * from zhubiao t inner join zhubiaofushu t1
on t.fid= t1.id

select t1.* from zhubiao t inner join zhubiaofushu t1
on t.fid= t1.id

select distinct t1.* from zhubiao t inner join zhubiaofushu t1
on t.fid= t1.id
order by t1.id asc

ID NAME 
-------------------- -------------------- 
1 1班 
2 2班 

2 rows selected

ID NAME FID ID NAME 
-------------------- -------------------- -------------------- -------------------- -------------------- 
1 小王 1 1 1班 
2 小唐 1 1 1班 
3 小宇 2 2 2班 
4 小丹 2 2 2班 

4 rows selected

ID NAME 
-------------------- -------------------- 
1 1班 
1 1班 
2 2班 
2 2班 

4 rows selected

ID NAME 
-------------------- -------------------- 
1 1班 
2 2班 

2 rows selected