What is difference between keep and joins? and where we can use keep instead of join?

[priyasingh]

I am confused about using JOINs. When I use a left or right join, how do I determine which table is the main one and which one is the secondary table? In KEEP, the results are the same whether I use left, right, or inner joins.

[Chanty4u · Accepted solution]

Hi 

Please reffer below 

https://community.qlik.com/t5/QlikView-App-Dev/Difference-between-Join-and-Keep/td-p/629338