SQL Query

[stuck]

How do i write this query

List all columns in Dept where that have no courses.
(Dept and Course are tables and the join on dept.ddept = course.cdept)??????????help

 

[balor]

SELECT Dept.* FROM Dept LEFT OUTER JOIN course ON dept.ddept = course.cdept WHERE course.cdept IS NULL;