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 needing a join somewhere...
Yes. You need to join organizations, probably to courses. 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. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
