Or change the first line to: select distinct t.ID (again assumes SQL Server)
Carl On 9/26/2011 10:44 AM, Josh Nathanson wrote: > 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:347718 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm