Data view after join-load

[markgraham123]

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.

[alexandros17]

Please share your 3 tables ...