Question: Ingredient ID: 1 , Name: Cayenne Pepper ID: 2 , Name: Pasta noodle ID: 3 , Name: Fresh tomato ID: 4 , Name: Sugar Recipe
Ingredient
ID: Name: Cayenne Pepper
ID: Name: Pasta noodle
ID: Name: Fresh tomato
ID: Name: Sugar
Recipe
ID: Name: Lasagna
ID: Name: Chocolate Chip Cookies
Given the above data for a recipe database, how many records would be included in the result set for the following query?
SELECT Recipe.name, Ingredient.name
FROM Recipe
CROSS JOIN Ingredient;
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
