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
Wow... join conditions in the where clause... Haven't seen those for years :) Looks like you have a cartesian join between organizations and the rest of your dataset... Need to join organizations to something. -Original Message- From: Jillian Carroll [mailto:[EMAIL PROTECTED] Sent: