查询学过"张三"老师授课的同学的信息
select s_id,s_name,s_sex from student
where s_id
in(select s_id from score where c_id=02);
如何用MySQL查询"学过张三老师课的同学们的信息"。
最新推荐文章于 2022-12-08 14:06:17 发布
查询学过"张三"老师授课的同学的信息
select s_id,s_name,s_sex from student
where s_id
in(select s_id from score where c_id=02);