5 Replies Latest reply: Sep 20, 2018 2:01 AM by Mohammed Mukram Ali RSS

    Reg: How to create joins & populate the field

    Tapan Diwanji

      If I have two Tables, EMP and SALES and want to populate certain values. Can someone guide me how can I write joins and where ? How can I populate the Dimension value by creating a join of two or more tables ?

       

      For eg.

       

      EMP

      EMPNONAME
      1A
      2B

      SALES

      EMPNOCITYSALES
      1X100
      2Y200

       

      TO BE

      RESULT


      EMPNOCITYSALESNAME
      1X100A
      2Y200B