If someone can help me figure out how to do this SQL query, I would be most appreciative. I have three relevant tables, ingredient_all (IngredientID, IngredientName, IngredientType), ingredient_similar (IngSimID, IngredientID), and recipe_ingredient (RecIngID, RecipeID, IngredientID, Amount, Unit)

Now, I want to find every recipe ingredient that has a similar ingredient and display it on a table, like so:

Recipe Ingredient.......Similar Ingredient
----------------------------------------------------------
.........Butter..........|.........Margerine
Granulated Sugar...|...Powdered Sugar
Granulated Sugar...|......Brown Sugar
.........Vanilla.........|.....Vanilla Extract
....Butterscotch.....|......Butter Extract

If I craft the following select statement:

SELECT ingredient_similar.ingsimid, ingredient_all.ingredientname
FROM ingredient_all, ingredient_similar, recipe_ingredient
WHERE ingredient_all.ingredientid=recipe_ingredient.ingredientid AND ingredient_all.ingredientid=ingredient_similar.ingredientid

then it returns the following data:

...IngredientName........IngSimID (ID for set of similar ingredients)
----------------------------------------------------------
.........Butter..........|..........1
Granulated Sugar..|..........2
........Vanilla..........|..........3
....Butterscotch.....|..........4

This search gives the following results:

SELECT ingredient_all.ingredientname, ingredient_similar.ingsimid
FROM ingredient_all, ingredient_similar
WHERE ingredient_all.ingredientid=ingredient_similar.ingredientid

...IngredientName........IngSimID (ID for set of similar ingredients)
----------------------------------------------------------
.........Butter..........|..........1
......Margerine.......|..........1
Granulated Sugar..|..........2
.Powdered Sugar...|..........2
........Vanilla..........|..........3
...Vanilla Extract...|..........3
....Butterscotch.....|..........4
....Butter Extract...|..........4
.........Cream.........|..........5
....Half and Half.....|..........5
....Brown Sugar.....|..........3

I really don't know how to craft a query to give the data I want... Any advice would be appreciated.

-Biscuits