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

mino · 08-23-2004, 03:12 AM

Another way of doing this is to do:

Code:

SELECT RecipeName
FROM Recipe
INNER JOIN RecipeIngredient AS Ingredient1 ON
     (Ingredient1.RecipeID = Recipe.RecipeID)
INNER JOIN RecipeIngredient AS Ingredient2 ON
     (Ingredient2.RecipeID = Recipe.RecipeID)
WHERE
     (Ingredient1.IngredientID = <IngredientID1>)
     AND (Ingredient2.IngredientID = <IngredientID2>)