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

magua · 08-20-2004, 08:14 PM

Use EXISTS checks. Eg:

Code:

SELECT RecipeName
FROM Recipe
WHERE EXISTS (
     SELECT *
     FROM RecipeIngredient
     WHERE RecipeIngredient.RecipeID = Recipe.RecipeID
     AND RecipeIngredit.IngredientID = <Ingredient1ID>
) AND EXISTS (
     SELECT *
     FROM RecipeIngredient
     WHERE RecipeIngredient.RecipeID = Recipe.RecipeID
     AND RecipeIngredit.IngredientID = <Ingredient2ID>
) ...etc

Welshbyte's answer will return recipes that match only one ingredient.