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 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4