WHERE CourseName not like '%Preventing Sexual Harassment%'
At 01:57 PM 2/24/2003 -0600, you wrote: >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 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
