Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select distinct Recipes.RecipeTitle
- from Recipes
- inner join Recipe_Ingredients on Recipes.RecipeID = Recipe_Ingredients.RecipeID
- inner join Ingredients on Recipe_Ingredients.IngredientID = Ingredients.IngredientID
- where Ingredients.IngredientName = 'Galic' and Recipe_Ingredients.Amount = (
- select max(Amout)
- from Recipe_Ingredients
- inner join Ingredients on Recipe_Ingredients.IngredientID = Ingredients.IngredientID
- where IngredientName = 'Garlic'
- );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement