Everett, Al wrote: >From: Jochem van Dieten [mailto:[EMAIL PROTECTED] >> >>SELECT >> EmpID >>FROM >> Employees >>WHERE NOT EXISTS ( >> SELECT >> 1 >> FROM >> Course >> WHERE >> CourseName = "Preventing Sexual Harassment" >> AND >> Course.EmpID = Employees.EmpID >> ) > > Shouldn't those be single quotes around the course name?
Not necessarily. Double quotes identify a field, single quotes a value. But the example code was with double quotes so I presume he wanted the field. 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 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
