4 Replies Latest reply: Sep 7, 2017 3:16 AM by Chan HS RSS

    how to compare values from the same column but different table

    Chan HS

      Hi,

       

      I have 2 tables, A and B with the same column Fruits. In table A, a fruit may be called banana,apple but in table B it is may be called apple.

      For example,

       

      AB
      Banana,AppleApple
      Orange,PineappleOrange
      Banana,PineappleOrange
      PineapplePineapple
      OrangeOrange

       

       

      I want to be able to match the columns together if the column in table A contains whatever is in table B. In this case, I want the first 2 rows to be matched together and show the results of table B. Is there any way to do this?

       

      Thanks!