Do you need to do a join ? Have you tried blending instead ?
I have consumer demographics in one file and sales revenue in another. The data has 1:1 relationship and could have been in a single file but its not, so i believe i have to join. Do you think blending will work in this scenario.