How to Join or concatenate of two fields from two different tables and make it into one field

[vikasshana]

Hi,

I do have three tables in my App as below.

Table1:

Load * Inline[

A

1];

left join

Load * Inline[

A, Level

1, AAA ];

Table 2:

Load * Inline[

Level1, Test1, Test2

BBB, CCC, DDD ];

So my requirement is I would like to combine fields Level and Level1 into one field and below is the output I'm expecting.

Level1

AAA

BBB

Regards,

Vikas