Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Recipe Table
- ID int
- name varchar
- steps varchar
- BaseIngredients Table
- ID int
- name varchar
- Ingredients Table
- ID int
- baseID int
- recipeID int
- measurement varchar
- select recipes.id, recipes.name from recipes inner join ingredients on recipes.id = ingredients.recipeID inner join baseingredient on ingredients.baseID = baseingredient.id where baseingredient.name = 'Eggs'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement