1 Reply Latest reply: Jul 9, 2015 10:34 AM by Alessandro Saccone RSS

    Data view after join-load

    Mark Graham



      I have 3 tables Table1, Table2, Table3.


      I'm joining 3 tables by a common field Join_Key.


      When i visualize the data in front end.   - Name1 From Table2   Name2 from Table3    ID from Table1


      Its showing as below:


      Name1      Name2     ID


      A                               1

      B                               1

      C                               1

      D                               1

                      E               1



      But how can i get the o/p like :


      Name1      Name2     ID


      A              E                1

      B              E                1

      C             E                 1

      D             E                 1


      Help pls.