SQL Query

From: <owais_anjum_at_my-deja.com>
Date: Thu, 29 Jul 1999 14:22:39 GMT
Message-ID: <7npo36$lqq$1@nnrp1.deja.com>

Hello

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 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 - 09:22:39 CDT