That sounds like you're getting everyone who signed up for the course. If you wanted to get everyone who didn't take the course, you might want to add another field for 'CourseTaken' or something, but that's just me.
Have you tried simply replace the = with <> ? Russ > -----Original Message----- > From: Kronenberger, Douglas [mailto:[EMAIL PROTECTED] > Sent: Monday, February 24, 2003 1:58 PM > To: CF-Talk > Subject: SQL: How do I a get list of everybody that doesn't > meet a certain criteria > > > I'm stumped. > > 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? > > Thanks in advance > > Doug Kronenberger > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
