上面的语名是通过mysqldump -u root -p test >c:/test.sql 导出的
下面是
in 语句
select name from student where t_id in (select t.id from teacher t where t.id<2 );
exists 语句
select s.name from student s where exists (select t.id from teacher t where t.id<2 and s.t_id=t.id);