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




Reply With Quote