Advertisement
Guest User

Untitled

a guest
Jun 16th, 2019
88
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.47 KB | None | 0 0
  1. select distinct Recipes.RecipeTitle
  2. from Recipes
  3. inner join Recipe_Ingredients on Recipes.RecipeID = Recipe_Ingredients.RecipeID
  4. inner join Ingredients on Recipe_Ingredients.IngredientID = Ingredients.IngredientID
  5. where Ingredients.IngredientName = 'Galic' and Recipe_Ingredients.Amount = (
  6. select max(Amout)
  7. from Recipe_Ingredients
  8. inner join Ingredients on Recipe_Ingredients.IngredientID = Ingredients.IngredientID
  9. where IngredientName = 'Garlic'
  10. );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement