RE: SQL: How do I a get list of everybody that doesn't meet a cer tain criteria

2003-02-25 Thread douglas . kronenberger
on 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: Joch

Re: SQL: How do I a get list of everybody that doesn't meet a cer tain criteria

2003-02-24 Thread Jochem van Dieten
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" >>

Re: SQL: How do I a get list of everybody that doesn't meet a cer tain criteria

2003-02-24 Thread Leonardo Crespo - Cftop.COM
Makes no diference for me , using mysql and cfmx on win2k. - Original Message - From: Everett, Al To: CF-Talk Sent: Monday, February 24, 2003 5:12 PM Subject: RE: SQL: How do I a get list of everybody that doesn't meet a cer tain criteria Shouldn't those be sin

RE: SQL: How do I a get list of everybody that doesn't meet a cer tain criteria

2003-02-24 Thread Everett, Al
Shouldn't those be single quotes around the course name? > -Original Message- > From: Jochem van Dieten [mailto:[EMAIL PROTECTED] > Sent: Monday, February 24, 2003 3:02 PM > To: CF-Talk > Subject: Re: SQL: How do I a get list of everybody that doesn't meet a > certain criteria > > > Kron