Tilted Forum Project Discussion Community - View Single Post - [SQL]How to select based on many-to-many relationship.

jakal · 08-19-2004, 04:36 PM

I'm embarrassed to ask this, but I have limited SQL experience.
I have a many to many relationship, and I need to select rows in one table based on more than one value in the other table. For example if you have a recipe table, an ingredient table, and an intersection relation then what would you need to do select all recipes based on two or more ingredients?
So the tables would be:
RECIPE(RecipeID, RecipeName)
INGREDIENT(IngredientID,IngredientName)
RECIPEINGREDIENT(IngredientID, RecipeID)

08-19-2004, 04:36 PM	#1 (permalink)
jakal Upright	[SQL]How to select based on many-to-many relationship. I'm embarrassed to ask this, but I have limited SQL experience. I have a many to many relationship, and I need to select rows in one table based on more than one value in the other table. For example if you have a recipe table, an ingredient table, and an intersection relation then what would you need to do select all recipes based on two or more ingredients? So the tables would be: RECIPE(RecipeID, RecipeName) INGREDIENT(IngredientID,IngredientName) RECIPEINGREDIENT(IngredientID, RecipeID)