title: Sub-queries filtering too many rows
body: <p>My Sub-queries are filtering out too many results. It Should be filtering out the 12 ingredients used in the 3 recipes in the sub-queries. There are a total  79 Ingredients so the query should return 67 rows. Currently my query is returning 54.</p>
  
  <p>I'm unsure why but if I change the second WHERE condition to an OR instead of AND I get 68 rows which is only one off what I'm expecting</p>
  
  <p>Query I'm trying to create:</p>
  
  <p><em>(5) Find the IDs and names of all ingredients not used in Irish Stew,
  Pollo Picoso, or Roast Beef. (2 columns, 67 rows)</em></p>
  
  <pre><code>select distinct Recipes.RecipeID, Ingredients.IngredientName
  from Recipes
  inner join Recipe_Ingredients on Recipes.RecipeID = Recipe_Ingredients.RecipeID
  inner join Ingredients on Recipe_Ingredients.IngredientID = Ingredients.IngredientID
  where Ingredients.IngredientID NOT IN
      (select distinct Ingredients.IngredientID
      from Recipes
      join Recipe_Ingredients on Recipes.RecipeID = Recipe_Ingredients.RecipeID
      join Ingredients on Recipe_Ingredients.IngredientID = Ingredients.IngredientID
      where Recipes.RecipeTitle = 'Roast Beef')
  and Ingredients.IngredientID NOT IN
      (select distinct Ingredients.IngredientID
      from Recipes
      join Recipe_Ingredients on Recipes.RecipeID = Recipe_Ingredients.RecipeID
      join Ingredients on Recipe_Ingredients.IngredientID = Ingredients.IngredientID
      where Recipes.RecipeTitle = 'Irish Stew')
  and Ingredients.IngredientID NOT IN
      (select distinct Ingredients.IngredientID
      from Recipes
      join Recipe_Ingredients on Recipes.RecipeID = Recipe_Ingredients.RecipeID
      join Ingredients on Recipe_Ingredients.IngredientID = Ingredients.IngredientID
      where Recipes.RecipeTitle = 'Pollo Picoso');
  </code></pre>
  
  <p>Database Diagram:
  <a href="https://i.stack.imgur.com/tSz29.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/tSz29.jpg" alt="enter image description here"></a></p>
  
  <p><a href="https://dbfiddle.uk/?rdbms=sqlserver_2019&amp;fiddle=ba5decece2de32495488876cc0b86e52" rel="nofollow noreferrer">DB Fiddble I created</a></p>