SQL Query Problem with Not Exists

[dom24]

Hi,

Can someone please tell me how to write the query for the following problem as I can't seem to get it right.

I have 2 tables, one named CourseComplete and one named Validation. Both contain the fields CourseKey and Staffno. I want to select all the records from coursecomplete where the coursekey and staffno combination are not in the Validation table.

I currently have:

SELECT * from coursecomplete
WHERE NOT EXISTS (select staffno, coursekey from validation)

but this doesn't work.

Thanks.

 

[dom24]

I hate how you get the answer soon as you post!

It should've been:

SELECT * from coursecomplete
WHERE NOT EXISTS (select * from validation where validation.staffno = coursecomplete.staffno
and validation.coursekey = coursecomplete.coursekey)

thanks anyway.