BUG: Regression in join of non_unique_indexes (GH6329)

closes #6329