How can I write a basic SQL query to accomplish the question (3) in the picture? Would I have to use a sub query?



This post was edited by Trig on Dec 6 2015 08:40pm

i would use a subquery, but you can do a join as well.

where 1=1
and courseid = '3113'
and facultyid not in (
select facultyid from qualified where courseid = '4930'
)