Join query

Mon, 22 Dec 2014 04:14:31 GMT

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

Re: Join query

sujeetsingh — Mon, 22 Dec 2014 04:28:23 GMT

Keys are not matching.

Why right why not natural join

if all the fields are same then use concatenate