The image shows the view DSAGENT$MODELING_DATA_CLEAN_A6CB and the logic of the exact join that is used.
DSAGENT$MODELING_DATA_CLEAN_A6CB