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

Reply via email to