2 Replies Latest reply: May 12, 2016 2:16 PM by Xia Wang RSS

    How to change values when two tables joined?

    Xia Wang

      Hi,

       

      I have two tables and the 2nd table left join the first one. My question is how to change value in Quality based on value in Product?

      For example, if Product name starts with "C", change value of Quality to "Bad". Please let me know. Thanks.

         

      Table A
      Prod IDProductType
      1AppleFruit
      2BananaFruit
      3BikeVehicle
      4CarVehicle
      5CatAnimal

       

       

         

      Table B
      TypeSourceQuality
      FruitUSAAmazing
      VehicleChina

      Great

       

      AnimalMexicoAwesome