select a.* from student a left join handin_works b on a.stud_id=b.stud_id where b.stud_id is null and b.work_id='Asp.net应用 -1'
USE stu SELECT * FROM dbo.student WHERE stud_id NOT IN(SELECT stud_id FROM dbo.handin_works) ORDER BY stud_id ASC
SELECT * FROM dbo.student WHERE stud_id NOT IN(SELECT stud_id FROM dbo.handin_works WHERE work_id LIKE '软件工程%') OR stud_id NOT IN(SELECT stud_id FROM dbo.handin_works WHERE work_id LIKE 'Asp.net应用%') ORDER BY stud_id ASC
on a.stud_id=b.stud_id
where b.stud_id is null and b.work_id='Asp.net应用 -1'
USE stu
SELECT *
FROM dbo.student
WHERE stud_id NOT IN(SELECT stud_id
FROM dbo.handin_works)
ORDER BY stud_id ASC
SELECT *
FROM dbo.student
WHERE stud_id NOT IN(SELECT stud_id
FROM dbo.handin_works
WHERE work_id LIKE '软件工程%')
OR stud_id NOT IN(SELECT stud_id
FROM dbo.handin_works
WHERE work_id LIKE 'Asp.net应用%')
ORDER BY stud_id ASC