Jump to content

Hermii

Members
  • Content Count

    1
  • Joined

  • Last visited

Community Reputation

0 Neutral

About Hermii

  • Rank
    Newbie
  1. Hermii

    Help me

    Sql newbie here, Im stuck on a problem. I have a recipe ingredient table, and I want to calculate the price for a whole recipe rounded up to whole ingredient units. Every recipe has one row per ingredient and every ingredient has a price. So I this sql. select recipe_id_label, recipe_name, variation_name, portion_size, menu_id, variation_name, sum (recipe_order_ingredient_quantity * ingredient_expected_cost) from mb.weekly_menus_recipes_ingredients where recipe_id_label = '30943' and portion_size = '2' group by recipe_id_label, recipe_name, variation_name, por
×
×
  • Create New...