-- 找出没选过‘liming’ 老师的所有学生姓名sql语句
SELECT student_name FROM students WHERE student_name NOT IN (SELECT student_name FROM teachers WHERE teacher_name = 'liming')
原文地址: https://www.cveoy.top/t/topic/iaGM 著作权归作者所有。请勿转载和采集!
安全问答是一个知识全球问答,包含丰富的问答知识
SELECT student_name FROM students WHERE student_name NOT IN (SELECT student_name FROM teachers WHERE teacher_name = 'liming')
原文地址: https://www.cveoy.top/t/topic/iaGM 著作权归作者所有。请勿转载和采集!