Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

Recursive Queries

Introduction
4. Table recipe_ingredients
Quiz
Congratulations

Instruction

The next table is the recipe_ingredients table. This table assigns ingredient data to specific recipes. It refers to the recipe and ingredient tables.

Exercise

Select all data from the recipe_ingredients table. This table has columns:

  • id – a unique identifier given for every recipe/ingredient combination,
  • recipe_id – ID of a given recipe from the recipe table,
  • ingredient_id - ID of a given ingredient from the ingredient table.