Hmm. That's an idea, though not quite that fashion, but that's because you don't know my table structure... going to give this a whirl. Thanks for the mental shove :)
At 02:41 PM 1/27/2003 -0500, you wrote: >What about left joining to TableB twice: > >SELECT DISTINCT A.*, B.FieldID, B.FieldValue >FROM TableA A LEFT OUTER JOIN TableB B >ON A.KeyedField = B.KeyedField, > TableA A LEFT OUTER JOIN TableB C > ON A.KeyedField = C.KeyedField >WHERE 1 = 1 AND >( >( B.CustomFieldID = 23 AND B.FieldValue = 'something' ) >And >( C.CustomFieldID = 24 AND C.FieldValue = '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 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
