Two Tables Join

[Anonymous]

Hi, how can I merge these two tables and obtain output in jpg attachment?

Thank You very much!!!!!

[YoussefBelloum]

Hi,

TAB1:

LOAD

        autonumber(Rows&field1&field2) as key,

        Rows,

        field1,

        field2,

        field3

FROM TAB1;

OUTER JOIN

TAB2:

LOAD

          autonumber(Rows&field1&field2) as key,

          field4

FROM TAB2;

[lironbaram]

load *

from Tab1;

join

load Rows,Field4

from Tab2

[prma7799]

Please check