2 Replies Latest reply on Sep 12, 2019 1:17 PM by jeremiah.aquino

    How to join 2 tables with multiple category

    jeremiah.aquino

      I'm stuck for many hours figuring out how to solve this. Please help

       

      I have 2 tables

       

      Table 1

      ProjectCatchment
      Proj APS-14
      Proj BPS-23
      Proj CPS-14, PS-23

       

      Serial No.
      Catchment
      101PS-14
      201PS-23
      301PS-5

        

      Resulting table:

      ProjectSerial No.
      Catchment
      Proj A101PS-14
      Proj B201PS-23
      Proj C101PS-14
      Proj C201PS-23

       

       

      I want to JOIN the two tables based on Catchment field but I can't figure out how. Thanks in advance!