Conditional SQL Query Not Working

2003-07-03 Thread Jillian Carroll
I have a form, that asks for a number of 'conditions' in order to find an attendee for a course. The problem is, I've put together a query that returns too many results / not the correct results. Every row returned is returned multiple times. I'm wondering if I'm needing a join somewhere... or

Re: Conditional SQL Query Not Working

2003-07-03 Thread Jochem van Dieten
Jillian Carroll wrote: I have a form, that asks for a number of 'conditions' in order to find an attendee for a course. The problem is, I've put together a query that returns too many results / not the correct results. Every row returned is returned multiple times. I'm wondering if I'm

RE: Conditional SQL Query Not Working

2003-07-03 Thread Costas Piliotis
: Thursday, July 03, 2003 6:17 AM To: CF-Talk Subject: Conditional SQL Query Not Working I have a form, that asks for a number of 'conditions' in order to find an attendee for a course. The problem is, I've put together a query that returns too many results / not the correct results. Every row