title: SQL Query to select customers who have already purchased all the items from their Wishlist
body: <p>I am trying to write a query and as it is a bit complex, I am not able to get the right results.</p>
  <p><strong>Goal of the query:</strong> Get list of Customer who have bought all the items from their Wishlist?</p>
  <p><em>I have 2 tables and the fields as given below,</em></p>
  <ol>
  <li><p><strong>Customer_Orders :</strong> <code>Customer_ID</code>, <code>Order_ID</code>, <code>Order_date</code> , <code>Product_ID</code>, <code>email</code></p>
  </li>
  <li><p><strong>Wishlist :</strong> <code>Customer_ID</code>, <code>Created_Date</code> , <code>Product_ID</code></p>
  </li>
  </ol>
  <p>I was only able to write the below query, which just checks the products customer has bought from Wishlist</p>
  <pre><code>select w.Customer_ID,w.Product_ID
  from Wishlist w
  inner join Customer_Orders od
  on od.Product_ID=w.Prodcuct_ID and od.Customer_ID=w.Customer_ID
  </code></pre>
  <p>What I want instead is to fetch those customers(Customer_ID) who have bought all the items from their <code>Wishlist</code>.</p>
  <p>Please can anyone help me know how the query should be ??</p>