Btw, what is that SQL list? Matthew Small IT Supervisor Showstopper National Dance Competitions 3660 Old Kings Hwy Murrells Inlet, SC 29576 843-357-1847 http://www.showstopperonline.com
-----Original Message----- From: Scott Weikert [mailto:[EMAIL PROTECTED]] Sent: Monday, January 27, 2003 3:37 PM To: CF-Talk Subject: Re: SQL: Odd Select Issue - solved What I needed was multiple RIGHT JOINS on the second table instead of doing checks in the main WHERE clause. A guy on the SQL list pushed me in the right direction... SELECT A.* FROM TableA A RIGHT JOIN TableB B2 ON S.Email = B2.Email AND S.PublicationID = B2.PublicationID AND B2.CustomFieldID = 23 AND C2.FieldValue like 'something' RIGHT JOIN TableB B3 ON S.Email = B3.Email AND S.PublicationID = B3.PublicationID AND B3.CustomFieldID = 24 AND B3.FieldValue like 'something else' ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
