CODE EXAMPLE FOR SQL

sql query contains multiple ids

SELECT i.Container
FROM Inventory i 
WHERE i.Sku in (S1, S2)
GROUP BY i.Container
HAVING COUNT(i.Sku) = 2;