Difference between keep and joins with example

[#1]

please help me with the difference between keep and join with example. and also about when to use keep/join..

[Anonymous]

This was very Helpful, Thank you

[Sivapriya_d]

Awesome. Thanks ,This explains a lot but can you please give some examples when to use  it.

[oelahrach]

Very helpful share, Thank you!

[Channa]

in case of left Keep

you will see VV also in "B" but Column "C" you will see "-"

behavior wise same as Left join