sc_left_join function

Performs various checks after a left-join was performed