Skorpius

MySQL Joins with Where Clause

May 25th, 2022 (edited)
657
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.46 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.        WHERE section = 'Cake';
  7.        ";
Add Comment
Please, Sign In to add comment