Yup, I think Carl's is the best, though you'd probably want to throw a GROUP BY in there so you don't get multiple rows for the same ID.
-- Josh On Mon, Sep 26, 2011 at 10:41 AM, Carl Von Stetten <vonner.li...@vonner.net>wrote: > > Richard, > > I think this will work (untested, assumes SQL Server): > > select t.ID > from mytable t > inner join mytable a on t.id = a.id and a.value = 'A' > inner join mytable b on t.id = b.id and b.value = 'B' > inner join mytable c on t.id = c.id and c.value = 'C' > > HTH, > Carl > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:347717 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm