Thank you gentlemen, I think this is just what I need. It was my mistake I think I do need single quotes. Access does seem to care.
Any recommendations on a good SQL book. Right now I'm using Access to help build SQL statements but they sure are messy and I would have never found you solution by my usual method. Again Thanks -----Original Message----- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Monday, February 24, 2003 4:11 PM To: CF-Talk Subject: Re: SQL: How do I a get list of everybody that doesn't meet a cer tain criteria 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 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
