SELECT * FROM stuInfo
SELECT * FROM stumarks

/*--采用IN子查詢，查看參加考試的學員名單--*/
SELECT stuName FROM stuInfo
  WHERE stuNo IN (SELECT stuNo FROM stuMarks)
GO

/*--采用NOT IN子查詢，查看未參加考試的學員名單--*/
SELECT stuName FROM stuInfo
  WHERE stuNo NOT IN (SELECT stuNo FROM stuMarks)
GO