Join query

[#1]

TableRightJoin:

//NoConcatenate

Load * inline

[

A,B,C

1,aa,e

2,bb,f

3,cc,g

4,dd

]

;

Right Join(TableRightJoin)

TabRightJoin:

Load * inline

[

A,B,C

e,xx,x

f,yy,y

g,cc,z

5,tt

]

;

QUALIFY *;

TabRightJoin:

Load * Resident TableRightJoin;

UNQUALIFY *;

DROP Table TableRightJoin;

Exit Script;

My Output:

e     xx

f     yy

g     cc

5     tt

On what basis is the result working ? as the qualify *; is present I believe all the fields from table2 must come right?

e     xx     x

f     yy     y

g     cc     z

[sujeetsingh · Accepted solution]

Keys are not matching.

Why right why not natural join

if all the fields are same then use concatenate