selecting certain items

hey,

I have the following table which keeps track of items in a kit.
fields: kitid, inventoryid, qty.

I want to pull out kitids that have 2 items in them (7845 and 6340).
I can do it if either one is in them but can't get to show only ones that have both items in them.

Thanks,

MA

are you using an SQL query?

Code:

---

SELECT *
FROM SOMETABLE
WHERE KITID=7845
OR KITID=6340

---

... if i understand you correctly.

Quote:

---

SELECT *
FROM SOMETABLE
WHERE KITID=7845
OR KITID=6340

---

How can KITID have both items in it?
Can you give me a sample of both items being in it?