SQL vs Qlikview join are Same?

[prma7799]

Hello Expert , 

I am doing join in SQL server and i am getting below output.

But when I have done this in qlikview with same data my Output will be different means i am getting only one column  'X'

X:
Load * Inline [
X
1
0
1
0
];
left join
Y:
LOAD * Inline [
X
1
0
1
0
];

Please reply on this...

[prma7799]

Anyone can look into this ...

[Or]

https://community.qlik.com/t5/QlikView-Creating-Analytics/Understanding-Join-Keep-and-Concatenate/td...

[Brett_Bleess · Accepted solution]

Have a look at the following Design Blog post as well, may shed some further light upon things:

https://community.qlik.com/t5/Qlik-Design-Blog/To-Join-or-not-to-Join/ba-p/1463102

And just in case, here is Help link which may help as well:

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Scripting/Scrip...

Regards,
Brett