查询未填“分组填写名单”但“选课名单”里有学号的人
SELECT * FROM `选课名单`
WHERE
NOT EXISTS (
SELECT `学号`
FROM `分组填写名单`
WHERE `选课名单`.`学号` = `分组填写名单`.`学号` );
查询未填“分组填写名单”但“选课名单”里有学号的人
SELECT * FROM `选课名单`
WHERE
NOT EXISTS (
SELECT `学号`
FROM `分组填写名单`
WHERE `选课名单`.`学号` = `分组填写名单`.`学号` );