首页
科技
登录
6mi
u
盘
搜
搜 索
科技
– 8、查询没学过“张三“老师授课的同学的信息
– 8、查询没学过“张三“老师授课的同学的信息
科技
2022-08-19
107
– 8、查询没学过"张三"老师授课的同学的信息
SELECT st.* FROM student st WHERE st.s_id NOT IN (SELECT sc.s_id FROM score sc WHERE sc.c_id IN (SELECT c.c_id FROM course c,teacher t WHERE c.t_id=t.t_id AND t.t_name='张三'))
转载请注明原文地址:https://blackberry.8miu.com/read-16788.html
最新回复
(
0
)