title: Finding all the orders who did not have at least one item labeled Confections
body: <p>I have to use a subquery in order to find all the orders that didn't have at least one item in confections. I'm having a hard time with subqueries so any help would be appreciated. This is what I have so far.</p>
  
  <pre><code>SELECT O.orderid, O.orderdate, C.custid, C.companyname
  FROM Sales.Orders AS O JOIN Sales.Customers AS C ON O.custid = C.custid
  JOIN Sales.OrderDetails AS D ON D.orderid = O.orderid
  JOIN Production.Products AS P ON P.productid = D.productid
  WHERE EXISTS
   (SELECT P.productid FROM Production.Products AS P JOIN 
  Production.Categories AS CA
          ON P.categoryid = CA.categoryid JOIN Sales.OrderDetails AS D ON 
          D.orderid = O.orderid
          WHERE CA.categoryname NOT LIKE '%Confections%')
  </code></pre>