SQL查询：找出未选过特定老师课程的学生姓名
SELECT s.name FROM s WHERE NOT EXISTS ( SELECT * FROM sc WHERE s.s_id = sc.s_id AND sc.c_id IN ( SELECT c_id FROM c WHERE teacher = "liming" ) );
原文地址: https://www.cveoy.top/t/topic/pT6W 著作权归作者所有。请勿转载和采集!
安全问答是一个知识全球问答,包含丰富的问答知识
SELECT s.name FROM s WHERE NOT EXISTS ( SELECT * FROM sc WHERE s.s_id = sc.s_id AND sc.c_id IN ( SELECT c_id FROM c WHERE teacher = "liming" ) );
原文地址: https://www.cveoy.top/t/topic/pT6W 著作权归作者所有。请勿转载和采集!