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

    Data view after join-load

    Mark Graham

      Hi,

       

      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.