you need to join some of these tables twice to achieve this! Think about what you want, and then create the query by building up the steps, then editing the query to add more pieces. You want something like:
- select from ingredients to get the id where item is "butter" (one row)
- now join recipe_ingredients and recipes to see which recipes contain this ingredient
- this is where it gets interesting. You have a list of recipes, and you need to join recipe_ingredients and ingredients tables on AGAIN (give them different aliases each time!) to get the ingredients in the recipes you found in the previous step.