Natural Join?

[#1]

Hello!

The other day I was asking something in the Community because I was needing to create a single table with different dates from different tables and I was recommended to do the following, which actually worked for me:

Link:

     Load ACCOUNT_ID, DATE_PLANNED

     Resident TableA;

Join

     Load ACCOUNT_ID, DATE_CANCELLED

     Resident TableB;

Join

     Load ACCOUNT_ID, DATE_TESTED, DATE_SENT

     Resident TableC;

The thing is that I've never used the Join like that way, I usually use Inner & Left Join.

I wanted to know if that'd be the Natural Join and which is it's goal.

What's the difference to use Concatenate instead of that Join?

Thank you!!!

[#2]

Hi mart pabst,

                         Joint will match and merge whereas concatenate add data vertically irrespective of matching values.

Eg:

concatenate

table:

LOAD * INLINE [

    A, B

    1, 1

    2, 2

    3

    4

];

table1:

Concatenate

LOAD * INLINE [

    A

    1

    2 

];

Ans:

Table:(Takes first table name)

A,  B

1,  1

2,  2

3

4

1

2

Join

table:

LOAD * INLINE [

    A, B

    1, 1

    2, 2

    3

    4

];

table1:

join

LOAD * INLINE [

    A

    1

    2

];

Ans:

Table:(Takes first table name)

A,  B

1,  1

2,  2

3

4

Thank you

[anbu1984]

Fullouter join and concatenate

Concatenate,Left Join, Left Keep

[SunilChauhan]

i thing you only neeed to use concatenate between them. if there is  no link b/w them

but i wonder there might be link beteen them.

if there is link then use left join,right etc

hope this helps