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 Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
