Dear all,
I am trying to create a recipe database and one of the funtions is to generate shopping list based on the selected recipe.

at the moment, I have a table --recipe, a table--ingredient, and a cross over table, reIng.
Does anyone know how can I write a procedure with cursor that no matter how many recipes the user selected, a list of ingredients will be created based on that? one of things I can't solve is if an ingredient appears twice, how can I make them sum together..

THanks for your help!

select distinct * from ingredient where ingredient id in (
select ingredient_id from reing where recipe_id in (
selected_recipe_id, selected_recipe_id2, ...
)
);