SQL Query
From: <owais_anjum_at_my-deja.com>
Date: Thu, 29 Jul 1999 14:36:34 GMT
Message-ID: <7npoti$m8v$1_at_nnrp1.deja.com>
Hello
Date: Thu, 29 Jul 1999 14:36:34 GMT
Message-ID: <7npoti$m8v$1_at_nnrp1.deja.com>
Hello
[Quoted] [Quoted] I have a table with the following structure and data:
ITEM_ID RELATED_ITEM
aaa 111 aaa 222 aaa 333 bbb 111 bbb 777 xxx 909
The query I want should return all the item_id's against a given list of [Quoted] related_items. e.g. I want an item_id which has all of the listed related_items ('111',222','333').
I thought ALL was meant for such scenarios...but I've not had any success with it so far.
Waiting for opinions
Owais
Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.
Received on Thu Jul 29 1999 - 16:36:34 CEST