Advertisement
Guest User

Untitled

a guest
Jul 28th, 2017
51
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.37 KB | None | 0 0
  1. Recipe Table
  2. ID int
  3. name varchar
  4. steps varchar
  5.  
  6. BaseIngredients Table
  7. ID int
  8. name varchar
  9.  
  10. Ingredients Table
  11. ID int
  12. baseID int
  13. recipeID int
  14. measurement varchar
  15.  
  16. 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