left/right join/keeep

[#1]

but can we say tat by using join as tables r clubbed, memory is saved n performance will be better when compared to keep?

[terezagr]

have a look at this article: Understanding Join, Keep and Concatenate