thanks, works perfect! > Hi, > > i know this is probably a simple answer and i probably drunk too much > coffee! > > given the following sql data: > > ID value > -------- > 1 A > 1 B > 1 C > 2 A > 2 B > 3 A > 3 B > 3 C > > i need to run a query that says return me the ids that are linked to > values A and B and C. > so this query on the above data would return IDs 1 and 3 > > thanks :)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347720 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm