Skorpius

MySQL Join Tables

May 25th, 2022 (edited)
618
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.43 KB | None | 0 0
  1. $recipe = "SELECT * FROM recipes
  2.        JOIN recipe_ingredients ON recipes.recipe_id = recipe_ingredients.recipe_id
  3.        JOIN measurement_qty ON recipe_ingredients.measurement_quantity_id = measurement_qty.measurement_qty_id
  4.        JOIN measurement_units ON recipe_ingredients.measurement_id = measurement_units.measurement_id
  5.        JOIN ingredients ON recipe_ingredients.ingredient_id = ingredients.ingredient_id
  6.        ";
Add Comment
Please, Sign In to add comment