4 Replies Latest reply: May 11, 2014 3:59 AM by anbu cheliyan RSS

    Scripting problem in relating columns in the same table.

      Guys, I have the following table:

       

      item_idFood_nameFood_PriceClassificationClassifications
      1hamburguer10unhealthy
      2ice cream11unhealthy
      3steak12unhealthy
      4bread13healthy
      5coke14unhealthy
      6juice1healthy
      7green salad2healthy
      8mango3healthy
      9ham15healthy
      10cesar salad16unhealthy
      11chicken8healthy
      12fish8healthy
      13tofu5healthy
      Ajuice0.5healthycoke
      Bgreen salad1.5healthycesar salad
      Cmango2.5healthyice cream
      Dchicken7healthyhamburguer
      Efish7healthyhamburguer
      Ftofu4healthyhamburguer
      Gfish10healthyhamburguer

       

       

      I would like a script that everytime that it sees in the Classifications column a name, that they look for this name in the column "Food_name" (same table), and return it that "Food_name" item_id and Food_Price.

       

      How do we do that?