Left join result and where to find it

[iv_3021]

Hi! I'm new to qlik sense and I have a question regarding `join` operations. Sorry in advance if my question seems strange or something.

So, having a query like this:

LEFT JOIN (table2) LOAD * RESIDENT table1;

How come I'll have the concatenated result in the table2? How does it work and why? Where can I see something on the matter in the documentation?

[stevejoyce · Accepted solution]

Join is in the qlik documenation: https://help.qlik.com/en-US/sense/August2021/Subsystems/Hub/Content/Sense_Hub/Scripting/combine-tabl...

But this is typical sql function.  Only difference is Qlik joins on fields with same name(s) opposed to sql where you specify fields to join on.

[Or]

Adding to what Steve posted, it sounds like you might be looking for LEFT KEEP instead of LEFT JOIN.