HAH! Got it, I think. Seems to work so far. Steve, you were dang close...
took a RIGHT JOIN to put the finishing touch on it. Many thanks for that
much needed mental shove, it worked like a champ :)
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=6
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=6
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
