女生皮鞋:在mysql中实现嵌套查询

来源:百度文库 编辑:神马品牌网 时间:2024/05/12 17:17:49
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='上海')