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 MS SQL Server

Introduction
4. The RecipeIngredient table
Quiz
Congratulations

Instruction

The next table is the RecipeIngredient table. This table assigns ingredient data to specific recipes. It refers to the Recipe and Ingredient tables.

Exercise

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

  • Id – a unique identifier given to every recipe/ingredient combination,
  • RecipeId – the ID of a given recipe from the Recipe table,
  • IngredientId – the ID of a given ingredient from the Ingredient table.