사용하는 table이름 section, takes, student
select student.ID, student.name
from student as S
where not exists ( (select takes.course_id
from takes
where S.ID = takes.ID)
except
(select course_id
from section
where year >= 2009) );
저기서 S부분오류
S를 student로 고쳐서 전부 표현하면
takes.ID 5번째 행부분 끝에서 missing right parenthesis 오류 뜸
하..
댓글 0