Subquery Help

[mgalvan]

I'm new to SQL and I'm trying to do a subquery.
I'm not having any success. Can someone look at this query and tell me what I'm doing wrong.

Thanks,

:confused:

SELECT I.ItemID, D.ShortDesc, K.KitItemKey
FROM timKitCompList KL
INNER JOIN timItem I ON KL.CompItemKey = I.ItemKey
INNER JOIN timKit K ON KL.KitItemKey = K.KitItemKey
INNER JOIN timItemDescription D ON I.ItemKey = D.ItemKey
WHERE K.KitItemKey IN
(Select I.ItemID, D.ShortDesc, SUM(WB.QtyOnHand - WB.PendQtyDecrease) AS Available
FROM timitem I
INNER JOIN timkitcomplist KC ON I.ItemKey = KC.KitItemKey
INNER JOIN timInventory V ON I.ItemKey = V.ItemKey
INNER JOIN timWareHouse W ON V.WhseKey = W.WhseKey
INNER JOIN timWhseBinInvt WB ON I.ItemKey = WB.ItemKey
INNER JOIN timItemDescription D ON I.ItemKey = D.ItemKey
INNER JOIN timkit K ON KC.KitItemKey = K.KitItemKey
Group By I.ItemID, D.ShortDesc)

[lottalava]

You must do something like this:

select a.PRODUCT_ID, a.PRODUCT_NM
from PRODUCTS a
where a.PRODUCT_ID in ( select b.PRODUCT_ID from STORAGE b
where b.PRODUCT_ID = a.PRODUCT_ID )
:D