收获日2技能加点前卫:在mysql中实现嵌套查询

来源:百度文库 编辑:杭州交通信息网 时间:2024/05/10 05:32:38
select yr_student_info.name from yr_student_info where yr_student_info.school_id=(select yr_school_info.id from yr_school_info where yr_school_info.province='上海' and yr_school_info.city='上海')

select yr_student_info.name from yr_student_info where yr_student_info.school_id in (select yr_school_info.id from yr_school_info where yr_school_info.province='上海' and yr_school_info.city='上海')