If you have NULL or "" values for CourseName in your DB for your Employees that hasnt build the course you can use that in your where clause (where CourseName IS NULL OR CourseName = "".
But i think you have a Employees table, with all the Employees. You can make a query to select all employees form Employees table witch does not have a match in the Course table. Let me know if i am not making myself clear =) Leonardo Crespo ICQ: 198810 [EMAIL PROTECTED] ----- Original Message ----- From: Kronenberger, Douglas To: CF-Talk Sent: Monday, February 24, 2003 4:57 PM 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
