SQL statement to select from two tables with where

[GeezerUK]

I have two tables defined as follow:Courses\[code\]course ID course Name1 Math2 Science3 geography\[/code\]and another table (its use is to show enrolled students in courses):student_courses\[code\]course ID student ID Final cost1 2 1002 3 200\[/code\]I need a SQL statement that selects only the courses that a certain student (its value is a parameter from a control on my page -but that is not my problem) isn't enrolled in....My latest try is this:\[code\]SELECT Courses.[Course ID], Courses.[Course name] FROM Courses, student_courses where Courses.[Course ID] <> student_courses.[Course ID]\[/code\]