Listing 1: P Is a Subset of O
SELECT orderid
FROM Orders AS O
WHERE NOT EXISTS
  (SELECT * FROM #ProdList AS PL
   WHERE NOT EXISTS
     (SELECT * FROM OrderDetails AS OD
      WHERE OD.orderid = O.orderid 
      AND OD.productid = PL.productid))