Revert "Defaults to always do left join"

This reverts commit ae648dc79e568a7639add4837658035add592a3e.
Be more robust against joining against null