[AccessD] Basic Query Design

On 8 Feb 2006 at 20:36, Steve Erbach wrote:
 
> SELECT DISTINCT EmployeeID
> FROM tblEmployeeCourse AS EC1
> WHERE NOT EXISTS
>   ( SELECT CourseID FROM tblCourse
>     WHERE CourseID In (1,2,4,5) AND NOT EXISTS
>       ( SELECT * FROM tblEmployeeCourse AS EC2
>         WHERE EC2.CourseID = tblCourse.CourseID
>         AND EC2.EmployeeID = EC1.EmployeeID))
> 

Ouch! My head hurts!

-- 
Stuart