Re: SQL: How do I a get list of everybody that doesn't meet a certain criteria

[Jochem van Dieten]

Kronenberger, Douglas wrote:
> 
> I have a table that has multiple courses taken (CourseName) entries  for
> each employee (EmpID)
> 
> This gets me everybody that took the coures.
>       SELECT EmpID, CourseName
>       FROM Course
>       WHERE CourseName = "Preventing Sexual Harassment"
> 
> But how do I get everybody that didn't?

I presume you have a table "employees" that has EmpID as the primary 
key. In that case:

SELECT
        EmpID
FROM
        Employees
WHERE NOT EXISTS (
        SELECT
                1
        FROM
                Course
        WHERE
                CourseName = "Preventing Sexual Harassment"
                AND
                Course.EmpID = Employees.EmpID
                )

Jochem

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

                                Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4