Recently I got asked, what the best way to do a join between two large lists, into another list was? I always tend to answer that question with: it depends. Just like any other algorithm, there is...