你试试我写的
create view test6_06 as select a.sid sid,name from pub.student a where not exists((select cid from pub.course where cid is not null )minus(select b.cid cid from pub.student_course b,pub.course c where a.sid =b.sid and b.cid=c.cid and b.score>=60 ))
exist改成exists
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024