join with non primary selfKey