ass. in THEODBS

SELECT DISTINCT it.name as Item i.name as Ingredients
From madewith as m, ingredients as i, items as it
Where (m.ingredientid = i.ingredientid)
And (m.itemid = it.itemid)
And ((quantity * 3) > inventory);