Please note this is totally untested but it seems logical to me and should be syntactically correct. Its worth a try anyway. SQL gurus reading this may have a more efficient way to do it too, i'm far from an expert. Anyway, here goes:
Code:
SELECT *
FROM RECIPE
WHERE RECIPEINGREDIENT.RecipeID = RECIPE.RecipeID
AND RECIPEINGREDIENT.IngredientID = INGREDIENT.IngredientID
AND (INGREDIENT.IngredientName LIKE 'Eggs' OR INGREDIENT.IngredientName LIKE 'Bacon');
I've used 'Eggs' and 'Bacon' as examples here but more ingredients would be added by extending with more OR's between the parentheses.
Worth a try
welshbyte