How can I delete a record where a column is null, but the record I want to delete is part of another table.

For example I want to delete a course which has no students. The course table is linked to the students by course\_id

```
DELETE COURSE_ID
FROM COURSE
INNER JOIN STUDENT
ON COURSE.COURSE_ID = STUDENT.COURSE_ID
WHERE STUDENT_ID IS NULL;

```