I have a link table that contains meals, with their ingredients.
beans on toast (mealID 1):
beans (ingredientID 1)
bread (ingredientID 2)
butter (ingredientID 3)
The table looks like the following
What SQL statement can I use to return any meals that do not contain a specific ingredient?
So if for example I wanted to return meals that do not contain butter (ingredientID 3), what do I do? At the moment, the meal is still returned because it is returning the result from a tuple that is not butter, i.e. bread of beans.