Thanks Lowell

Hi Lowell,

To be more specific, I'd like to retrieve all of the people not in a course.

So where this retrieves all of the people in Course 3:

SELECT CourseName

,FirstName

,LastName

,Location

,DateTaken

,DateExpired

FROM dbo.TB__EmpCourse...

Thanks for the tip, realized i had a messup in the last query I posted. Hope this one is useful.