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 in PostgreSQL

Introduction
4. recipe_ingredients table
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 the following columns:

  • id – A unique identifier given to every recipe-ingredient combination.
  • recipe_id – The ID of a given recipe from the recipe table.
  • ingredient_id – The ID of a given ingredient from the ingredient table.