Revert "Remove Left join"

This reverts commit f54504725fc16939a27a333b1095de741a198be6.
Remove right join and merge record on join