用mysql查询哪些教师没有授课任务显示其姓名、性别和职称。子查询

SELECT t.name, t.gender, t.title FROM teacher t WHERE t.id NOT IN ( SELECT DISTINCT c.teacher_id FROM course c ) ORDER BY t.id;

原文地址: https://www.cveoy.top/t/topic/cKXr 著作权归作者所有。请勿转载和采集!