;WITH CTE AS(
SELECT * FROM 学生表,课程表
)
SELECT A.* FROM CTE A LEFT JOIN 选课表 B ON A.sno=B.sno WHERE B.sno IS NULL应该类似这样~~
SELECT * FROM 学生表,课程表
)
SELECT A.* FROM CTE A LEFT JOIN 选课表 B ON A.sno=B.sno WHERE B.sno IS NULL应该类似这样~~
;WITH CTE AS(
SELECT * FROM 学生表,课程表
)
SELECT A.* FROM CTE A LEFT JOIN 选课表 B ON A.sno=B.sno AND A.cno=b.cno WHERE B.sno IS NULL
(
select * from 学生表,课程表
)
select a.* from cte as a left join 选课表 as b on a.sno=b.sno and a.cno=b.cno where b.cno is null
(select * from 学生表,课程表) as a
left join 选课表 as b
on a.sno=b.sno and a.cno=b.cno
where b.cno is null