Hi @bskr ,
Can you check the article below by @abacon, where he explains in detail the concepts of Join and RLS
Thanks & Regards Biswajit Dash