CLN: simplify join take call
We can track down the dtypes that get passed to `_get_result_indexer`, and since it is always int64/int64, we can reduce the call to `algos.take_nd` down to a direct cython call.

This removes the dependency of this module on non-cython parts of the code