On Sat, Jan 15, 2011 at 14:56, Barbara Woolums <barb.wool...@ymail.com>wrote:
> Hi there, > > Could someone please tell me why the following query won't work > > select DISTINCT get_unit(unit) as unit, get_ingredient(ing) as ing, > get_ing_aisle(1,ing) as aisle > from recipe_ing where recipe in(1084, 1086, 1012, 618) and qtydec>0 and ing > not in(select ing from excluded_ing where owner=1) > order by aisle > > You seem to be mixing up the parameters for get_ing_aisle. Try *get_ing_aisle(ing,1) as aisle* instead
