Sunday, February 15, 2009


SELECT DISTINCT it.name as Item, i.name as Ingredient FROM madewith as m, ingredients as i, items as it WHERE m.itemid = it.itemid AND m.ingredientid = i.ingredientid AND quantity*3 > inventory

No comments: